Find and Clear INACTIVE SESSIONS


select 'alter system kill session '||' '||''''||s.sid||','||s.serial# ||''' immediate;' FROM   v$session s
WHERE  s.type!= 'BACKGROUND'
AND S.TYPE='USER'
AND S.USERNAME='<SCHEMA NAME>'
AND TRUNC(S.LOGON_TIME) < '11-DEC-2013' 
AND S.STATUS='INACTIVE'
-- and last_call_et > 300       -- more than 300 mins inactive

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: