Listar as sessões mortas(KILLED) no banco

select vs.sid,vs.serial#,vp.spid,vs.username,to_char(vs.logon_time,'dd/mm/yyyy hh24:mi:ss'),vs.status
FROM v$process vp, V$SESSION vs
where vp.addr = vs.paddr
and vp.addr = vs.paddr
and status='KILLED' ORDER BY USERNAME;


prompt IF RETURN SOME RESULT ON THIS QUERY, THE PROCESS NOT IN SO
select INST_ID,STATUS,sid,serial#,username,to_char(logon_time,'dd/mm/yyyy hh24:mi:ss') from gv$session where status='KILLED' ORDER BY USERNAME;


--monta comando para matar via sistema operacional, essa ação requer cuidado
--select 'kill -9 '||vp.spid
--FROM v$process vp, V$SESSION vs
--where vp.addr = vs.paddr
--and vp.addr = vs.paddr
--and status='KILLED';