RE: How to invoke Oracle clean up process to remove INACTIVE sessions?

That's exactly what I did a while back for our system. I did not know there was a metalink note, though. I basically wrote an unix shell script (clled by cron every 15 min) that goes through v$session looking for "KILLED" session(s) and then does "kill -9".

Hope this helps.

Guang

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Egor Starostin Sent: Wednesday, November 10, 2004 8:54 AM To: arul.kumar_at_bt.com
Cc: oracle-l_at_freelists.org
Subject: Re: How to invoke Oracle clean up process to remove INACTIVE sessions?

Arul,

> By any chance can we control this "auto-cleanup" timing and bring it down
to around 30 minutes or so. Every INACTIVE session after 30 minutes, should be killed? Please let me know your views on the same.

If you are in dedicated server environment then for the first step do the following:
alter system set resource_limit=true;
create profile only30minutes_of_inactivity limit idle_time 30;
alter user <username> profile only30minutes_of_inactivity;

For the next step, read Note:96170.1 on metalink which provides you the shell script for killing sniped (sessions with exeeded idle_time limit) sessions. You have to run this script by cron.

Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l