在sql窗口中
1.查詢當(dāng)前所有死鎖進(jìn)程的編號(hào)
select xidusn, object_id, session_id, locked_mode from v$locked_object;
(2).所有進(jìn)程編號(hào)
select username,sid,serial# from v$session;
(3)殺掉相關(guān)的死鎖進(jìn)程
alter system kill session 'sid,serial#';
(4)查詢死鎖oracle進(jìn)程對(duì)應(yīng)的系統(tǒng)進(jìn)程
select pro.spid from v$session ses,v$process pro where ses.sid=129 and ses.paddr=pro.addr;
(5)殺掉系統(tǒng)進(jìn)程
kill -9 pid
總結(jié):
select pro.spid,loc.xidusn,loc.object_id,loc.session_id,loc.locked_mode from v$locked_object loc,v$session ses,v$process pro where ses.sid=loc.session_id and ses.paddr=pro.addr;
kill -9 pid