--查询死锁
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';