show_locked_sql.sql

--显示产生锁定的sql语句

select  /*+  NO_MERGE(a)  NO_MERGE(b)  NO_MERGE(c)  */  a.username,  a.machine,  a.sid,

a.serial#, a.last_call_et "Seconds", b.id1, c.sql_text "SQL"
from v$session a, v$lock b, v$sqltext c
  where a.username is not null and a.lockwait = b.kaddr and c.hash_value =a.sql_hash_value;