Oracle - Query to detect active sessions, in order to kill them :)

discover_kill_sessions.sql

/*Query to detect active sessions, in order to kill them in Oracle */
SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.osuser,
       s.machine,
       s.program,
       'ALTER SYSTEM KILL SESSION '''||s.sid||','||s.serial#||''' IMMEDIATE;' as cmd
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND'
and s.MACHINE <> 'LT076458'
order by s.MACHINE, s.sid, s.SERIAL#;