oracle死锁处理

1.获取死锁sid和serial#

SELECT sess.sid,
  sess.serial#,
  lo.oracle_username,
  lo.os_user_name,
  ao.object_name,
  lo.locked_mode
FROM v$locked_object lo,
  dba_objects ao,
  v$session sess
WHERE ao.object_id = lo.object_id
AND lo.session_id  = sess.sid;

2.执行解锁语句

alter system kill session 'sid,serial#';

或者直接查询出来执行

SELECT 
    'alter system kill session '''||sess.sid||','||sess.serial#||''';' 
     as exec_sql 
FROM v$locked_object lo,dba_objects ao,v$session sess
WHERE ao.object_id = lo.object_id
AND lo.session_id  = sess.sid ;