Oracle中,一些工具命令(MEMO)

使用SQL来确认当前数据库的连接情况

SELECT * FROM V$SESSION;
SELECT * FROM V$TRANSACTION;


查看前一次执行的SQL内容
SELECT DISTINCT sq.* FROM v$session ss,v$sqltext sq
WHERE ss.prev_sql_addr = sq.address

ORDER BY sq.sql_id, sq.piece;

END

0 Responses to "Oracle中,一些工具命令(MEMO)"