oracle 死锁查询语句

SELECT s.username, l.object_id, l.session_id, s.serial#, l.oracle_username,
       l.os_user_name, l.process,'alter system kill session '''||l.session_id||','|| s.serial#||'''' as killSQL
  FROM v$locked_object l, v$session s
 WHERE l.session_id = s.SID

会直接生成解锁语句 killsql

 
 alter system kill session '783,30485'   // 第一个session_id, 第二个serial id

转载地址  https://blog.csdn.net/lin49940/article/details/4705995