Oracle死锁处理

原文：https://blog.youkuaiyun.com/maoyeqiu/article/details/51535941

 

查看死锁：

select sess.sid,
 sess.serial#,
lo.oracle_username,
 lo.os_user_name,
 ao.object_name,
 lo.locked_mode,
sess.machinefrom v$locked_object lo,
 dba_objects ao,
 v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; 

 

杀死对应的进程：

alter system kill session '738,1429';