All apps dba Blog is the blog contributed by Doyensys Employees, With the view to share the knowledge out of their experience.
Doyensys Is a Fast Growing Oracle Technology Based Solutions Company Located in the US And Offshore Delivery Centers in India. With rich experience In Oracle E-Business, Oracle Database, Oracle Application Express (APEX), Oracle J Developer, Oracle OBIEE and E-Business Suite
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)