get_sniped_PID.sql
Download Script
select 'kill -9 '||p.spid||'', s.username, logon_time from v$process p, v$session s where s.status = 'SNIPED' and s.username not like '%GIA%' and p.addr = s.paddr;
Download Script
select 'kill -9 '||p.spid||'', s.username, logon_time from v$process p, v$session s where s.status = 'SNIPED' and s.username not like '%GIA%' and p.addr = s.paddr;