SELECT o.object_name, s.machine, s.sid, s.serial#
FROM v$locked_object l, dba_objects o, v$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
ALTER SYSTEM KILL SESSION 'SID, SERIAL#';
亦可透過 Enterprise Manager 圖形介面操作。
先取得 OS 進程號 (SPID):
SELECT p.spid, s.osuser, s.program
FROM v$session s, v$process p
WHERE s.paddr = p.addr
AND s.sid = '上述 SID';
kill -9 SPID
orakill SID SPID
-- 範例
orakill orcl 12345
orakill.exe 位於 %ORACLE_HOME%\bin,專門終止 Oracle 線程。