セッションを切断する

書式）

alter system kill session 'sid, serial#';

例）

set pagesize 1000
set linesize 150
col SID for 999
col SERIAL# for 999999
col USERNAME for a10
col MACHINE for a10
col OSUSER for a10
col PROGRAM for a30
col STATUS for a10

select sid, serial#, username, machine, osuser, program, status from v$session;

 SID SERIAL# USERNAME   MACHINE    OSUSER     PROGRAM                        STATUS
---- ------- ---------- ---------- ---------- ------------------------------ ----------
 117     435 SYS        db01       oracle     sqlplus@db01 (TNS V1-V3)       INACTIVE
 119    1738 SYS        db01       oracle     sqlplus@db01 (TNS V1-V3)       ACTIVE

alter system kill session '117,435';

select sid, serial#, username, machine, osuser, program, status from v$session;

 SID SERIAL# USERNAME   MACHINE    OSUSER     PROGRAM                        STATUS
---- ------- ---------- ---------- ---------- ------------------------------ ----------
 117     435 SYS        db01       oracle     sqlplus@db01 (TNS V1-V3)       KILLED
 119    1738 SYS        db01       oracle     sqlplus@db01 (TNS V1-V3)       ACTIVE

http://634.ayumu-baby.com/oracle/oracle_killsession.html を参考にした。