--Query
Verificar Sessoes Existentes ...
SELECT s.sid,
s.serial#,
p.spid,
s.osuser,
s.program
FROM v$process p,
v$session s
WHERE p.addr = s.paddr
order by program;
--Executar o KILL
...
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;
--Query
Verificar Sessoes foi desconectada ...
SELECT s.sid,
s.serial#,
p.spid,
s.osuser,
s.program
FROM v$process p,
v$session s
WHERE p.addr = s.paddr
order by program
By Rômulo Ferrari
By Rômulo Ferrari