11g RAC KILL remote sessions

-- -------------------------------------
--
-- 11g RAC KILL remote sessions
--
-- -------------------------------------

column username format a12
column Kill format a55
column "Log on" format a25



select  s.inst_id "Inst",
 s.username
, to_char(s.LOGON_TIME, 'MM-MON-RRRR HH24:MI:SS') "Log on"
, 'alter system kill session '''||s.sid||','||s.serial#||',@'||s.inst_id||''' IMMEDIATE;' "Kill"
FROM  gv$session s
WHERE  s.username IS NOT NULL
AND s.username NOT IN ('DBSNMP', 'SYSMAN', 'SYS','PUBLIC')
ORDER BY s.username, s.inst_id, s.LOGON_TIME, substr(s.program,18,10)
/