监控执行的SQL

Posted on 2011-10-10 09:27 奥客阅读(207) 评论(0) 编辑收藏举报

SELECT a.sid, a.serial#, b.sql_text
FROM v$session a, v$sqltext b
WHERE a.sql_address = b.address
AND a.sid =242
ORDER BY b.piece