RE: How to invoke Oracle clean up process to remove INACTIVE sessions?
- From: <arul.kumar@xxxxxx>
- To: <gmei@xxxxxxxxxx>
- Date: Wed, 10 Nov 2004 16:05:44 -0000
All,
Thanks a lot for all your inputs, will try some of the solutions soon =
and get back to you.
Regards,
Arul.
-----Original Message-----
From: Guang Mei [mailto:gmei@xxxxxxxxxx]
Sent: 10 November 2004 15:52
To: egorst@xxxxxxxxx; Kumar,A,Arul,XGF3C C
Cc: oracle-l@xxxxxxxxxxxxx
Subject: 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=3Dtrue;
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: