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

Other related posts: