--查询死锁
Select substr(to_char(l.session_id) || ',' || to_char(s.serial#), 1, 12) sid_ser,
substr(l.os_user_name || '/' || l.oracle_username, 1, 12) username,
l.process,
p.spid,
substr(o.owner || '.' || o.object_name, 1, 35) owner_object,
decode(l.locked_mode,
1, 'No Lock',
2, 'Row Share',
3, 'Row Exclusive',
4, 'Share',
5, 'Share Row Excl',
6, 'Exclusive', null) locked_mode,
substr(s.status, 1, 8) status
from v$locked_object l,
all_objects o,
v$session s,
v$process p
where l.object_id = o.object_id
and l.session_id = s.sid
and s.paddr = p.addr
and s.status != 'KILLED';
--解除死锁 sid_ser为值-解锁标识
alter system kill session '37,937';