DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, October 3, 2015

How to kill the spid for inactive sessions logged in more than 15 minutes

SELECT 'kill -9 '|| spid || ''
FROM V$SESSION a,v$process b where
(a.USERNAME = 'TEST_USER' AND a.STATUS = 'INACTIVE' and a.seconds_in_wait > 900) or
(a.USERNAME = 'SECURITY' AND a.STATUS = 'INACTIVE' and a.seconds_in_wait > 7500)
and
paddr=addr
;

kill -9 11055262  

No comments: