Sessions That Are Idle for More Than 1 Hour

>>Script Language and Platform: Oracle
Find all of the sessions that are idle for more than 1 hr. Command to kill those sessions is also given.

Author: K Chithra

select sid,serial#,username,trunc

(last_call_et/3600,2)||' hr' 

last_call_et 

from V$session where

last_call_et > 3600 and username is not null

/

Note : last_call_et is in seconds .You can give where clause accordingly. Ex : for 2hrs:7200 etc. Once identified ,if you want to kill those session , you can use this command:

alter system kill session '<sid>,<serial#>';

Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided “as -is”, without any warranty, whether express or implied, of its accuracy, completeness, or fitness for a particular purpose… Disclaimer Continued

Back to Database Journal Home