Dead lock 檢查及處理

SELECT dob.OBJECT_NAME Table_Name,lo.SESSION_ID,vss.SERIAL#,vss.action Action,vss.osuser OSUSER, vss.machine, vss.process AP_PID,VPS.SPID DB_PID from v$locked_object lo, dba_objects dob, v$session vss, V$PROCESS VPS where lo.OBJECT_ID = dob.OBJECT_ID and lo.SESSION_ID = vss.SID AND VSS.paddr = VPS.addr order by 2,3,DOB.object_name; alter system kill session 'sid,serial'; 其實最好的辦法是要求AP修改程式.[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/202861/viewspace-785125/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/202861/viewspace-785125/