Oracle死锁 解锁。各位在使用Oracle的过程中，偶尔会遇到死锁问题，运用下面两条语句即可轻松解决。

– 查询死锁情况
SELECT dob.OBJECT_NAME Table_Name,
vss.SID,
vss.SERIAL#,
vss.action Action,
vss.osuser OSUSER,
vss.process AP_Process_ID,
VPS.SPID DB_Process_ID,
VSS.STATUS,
VSS.STATE
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;

– 根据上一步查到的sid,SERIAL#，执行下面这段话
alter system kill session ‘sid,SERIAL#’;