oracle数据_死锁处理

--(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';