死锁

 

select b.username,b.sid,b.serial#,logon_time 
from v$locked_object a,v$session b 
where a.session_id = b.sid order by b.logon_time;


select l.session_id,o.owner,o.object_name from
v$locked_object l,dba_objects o where l.object_id=o.object_id;


Select v2.username,v2.sid,v2.serial#,v2.logon_time From v$locked_object v1,v$session v2 Where v1.session_id=v2.sid order by v2.logon_time