1.The SQL*Plus Approch:

SELECT s.sid,
       s.serial#,
       s.osuser,
       s.program
FROM   v$session s;

SQL> ALTER SYSTEM KILL SESSION 'sid,serial#';

SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

2.The NT Approach:

SELECT s.sid,
       p.spid,
       s.osuser,
       s.program
FROM   v$process p,
       v$session s
WHERE p.addr = s.paddr;

C:> orakill ORACLE_SID spid

3.The UNIX Approach

% kill -9 spid

% ps -ef | grep ora

ITPub博客

Killing Oracle Sessions