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