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;

