Code to Kill a Runaway Database Process

Login as system and run:

col sid_serial format a20

select ''''||sid||', '||serial#||'''' sid_serial
,      username, status, server
from v$session;

SID_SERIAL           USERNAME                       STATUS   SERVER
-------------------- ------------------------------ -------- ---------
'25, 1132'           SYSTEM                         ACTIVE   DEDICATED
'28, 4'                                             ACTIVE   DEDICATED
'31, 2'                                             ACTIVE   DEDICATED

Use the sid, serial# combination in the following query

alter system kill session 'sid, serial#'

Example:

SQL> alter system kill session '32, 55696';