Monday, February 11, 2013

Query to find which sql is executing in a session



select a.sid, a.serial#, b.sql_text
   from v$session a, v$sqlarea b
    where a.sql_address=b.address
     and a.sid = :sid

No comments:

Post a Comment