欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

死锁解决方案

程序员文章站 2022-04-19 13:55:24
...

查找死锁sql:

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;

 

查找SID和SERIAL#

select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;

 

kill掉死锁

alter system kill session  'SID, SERIAL#'

alter system kill session '1683,8873';

alter system kill session '112,34771'

 

相关标签: 死锁