--(1)查看死锁对象
select s.username,l.object_id,l.session_id,s.SERIAL#,s.machine,s.STATUS from v$session s,v$locked_object l
where s.sid = l.session_id;
--(2)死锁处理语句(杀掉会话) 其中数字代表session_id,serial#
alter system kill session '393,63862';
--(1)查看死锁对象
select s.username,l.object_id,l.session_id,s.SERIAL#,s.machine,s.STATUS from v$session s,v$locked_object l
where s.sid = l.session_id;
--(2)死锁处理语句(杀掉会话) 其中数字代表session_id,serial#
alter system kill session '393,63862';