监控执行的SQL

   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

 

http://www.cnblogs.com/benio/archive/2011/03/10/1979419.html