死锁解决方案

查找死锁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'