select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id; 如果有死锁,查找该进程所在的spid: select pro.spid from v$session ses,v$process pro where ses.sid=24 and ses.paddr=pro.addr; 确认SPid: select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr 用OraKill orakill <sid> <spid> 如:orakill ORCL 2760
from v$locked_object a,dba_objects b
where b.object_id = a.object_id;
如果有死锁,查找该进程所在的spid:
select pro.spid from v$session ses,v$process pro where ses.sid=24 and ses.paddr=pro.addr;
确认SPid:
select spid, osuser, s.program from v$process p, v$session s where p.addr=s.paddr
用OraKill
orakill <sid> <spid>
如:orakill ORCL 2760