ɱOracle½ø³Ì

alter system kill session '²é³öµÄsid,²é³öµÄserial#';
ͨ過數據×ÖµäV$SESSION與V$LOCK來瞭½âÕýÔڵȴý鎖資Ô´µÄÓÃ戶
select a.username,a.sid,a.serial#,b.id1 from v$session a ,v$lock b
         Where a.lockwait = b.kaddr;
瞭½â鎖סÆäËûÓÃ戶µÄÓÃ戶進³Ì£¬·½·¨ÈçÏ£º
select a.username,a.sid,a.serial#,b.id1 from v$session a,v$lock b
         Where b.id1 in
                 (select distinct e.id1 from v$session d,v$lock e where d.lockwait = e.kaddr)
                 And a.sid = b.sid and b.request =0;