Oracle 查询死锁对象(摘)

查询死锁：

select object_name,
  machine,
  s.sid,
  p.spid,
  s.osuser,
  s.program,
  s.STATUS,
  s.ACTION,
  p.SERIAL#,
  l.SESSION_ID
  from v$locked_object l, dba_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;

杀进程：

alter system kill(l.SESSION_ID,p.SERIAL#)