删除锁

SELECT l.session_id sid, s.serial#, l.locked_mode,l.oracle_username,

l.os_user_name,s.machine, s.terminal, o.object_name, s.logon_time

FROM v$locke{d}_{o}bjectl,al{l}_{o}bjectso,v$session s

WHERE l.object_id = o.object_id

AND l.session_id = s.sid

ORDER BY sid, s.serial# ;

ALTER system KILL session ‘SID,serial#’;

如果发生 ora-00031:标记要终止的会话。

select spid, osuser, s.program

from v$sessions,v$process p

where s.paddr = p.addr

and s.sid =197;

1. 在linux上， kill -9 12345

2. 在windows上，C:\Documents and Settings\gg>orakill orcl 12345

orcl：表示要杀死的进程属于的实例名

12345：是要杀掉的线程号