oracle 检查死锁

检查存储过程是否死锁

select distinct ‘alter system kill session ’ || ‘’’’ || s.sid || ‘,’ ||

s.serial# || ‘’‘;’

FROM

dba_ddl_locks l,v$session s

where l.name =upper(‘存储过程名称’)

and s.sid=l.session_id;

检查表是否死锁

select distinct ‘alter system kill session ’ || ‘’’’ || s.sid || ‘,’ ||

s.serial# || ‘’‘;’

FROM

from v l o c k e d o b j e c t l , d b a o b j e c t s o , v locked_object l,dba_objects o ,v lockedo​bjectl,dbao​bjectso,vsession s

where l.object_id　=　o.object_id and l.session_id=s.sid;