Kill Oracle sessions

gistfile1.txt

/* List all session, except background processes*/
SELECT s.username,
     s.osuser,
     s.sid,
     s.serial#,
     p.spid,
     s.status,
     s.machine,
     s.program,
     TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time
   FROM v$session s
  inner join v$process p
     on s.paddr = p.addr
  WHERE s.status = 'ACTIVE'
    and s.type <> 'BACKGROUND';

/* Kill one specific session*/
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;