oracle死锁查询

select /*+ NO_MERGE(a) NO_MERGE(b) NO_MERGE(c) */ 'Wait' "Status", a.username, a.machine, a.sid, a.serial#, a.last_call_et "Seconds", b.id1 from v$session a, v$lock b where a.username is not null and a.lockwait = b.kaddr union select /*+ NO_MERGE(a) NO_MERGE(b) NO_MERGE(c) */ 'Lock' "Status", a.username, a.machine, a.sid, a.serial#, a.last_call_et "Seconds", b.id1 from v$session a, v$lock b where b.id1 in (select /*+ NO_MERGE(d) NO_MERGE(e) */ distinct e.id1 from v$session d, v$lock e where d.lockwait = e.kaddr) and a.username is not null and a.sid = b.sid and b.request=0 --alter system kill session 'sid, serial#'; select t2.username,t2.sid,t2.serial#,t2.logon_time,t1.locked_mode,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time