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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Egor Starostin
Sent: Wednesday, November 10, 2004 8:54 AM
To: arul.kumar@xxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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

Other related posts: