Oracle Enterprise Manager

Targets - Databases - MyDB - Performance - Search Sessions

• Specify  search criteria. (See examples at right)

• Click on the SID of the session you want to kill

• Select Kill Session

Identify sid and serial# of session to kill...

SET PAGESIZE 40

SET LINESIZE 180

COLUMN sid       FORMAT 999 WRAP

COLUMN serial#   FORMAT 99999999 WRAP

COLUMN terminal  FORMAT a10 WRAP

COLUMN username  FORMAT a7 WRAP

COLUMN status    FORMAT a8 WRAP

COLUMN osuser    FORMAT a7 WRAP

COLUMN process   FORMAT a7 WRAP

COLUMN machine   FORMAT a20 WRAP

COLUMN terminal  FORMAT a10 WRAP

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-Mon-RR HH24:MI:SS';

SELECT sid,

       serial#,

       username,

       status,

       osuser,

       process,

       machine,

       terminal,

       program,

       logon_time

  FROM v$session;

Kill session...

ALTER SYSTEM KILL SESSION '&sid, &serial';

ALTER SYSTEM DISCONNECT SESSION '&sid, &serial' IMMEDIATE;