select a.inst_id, a.username,a.osuser, a.sid, a.serial#, a.status, round(a.last_call_et/60) Min, a.WAIT_CLASS, 
a.event, a.machine,a.sql_id , c.sql_text, 'alter system kill session ' || '''' || sid || ',' || serial#|| '''' || ' IMMEDIATE;' cmd
from gv$session a, v$sqlarea c
where status = 'ACTIVE' 
and a.sql_hash_value = c.hash_value
and username is not null
and username <> 'SYS'  
--and username
;