Re: automatic disconnect from idle application ...

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 30 Sep 2001 12:56:05 +1000
Message-ID: <3bb68944@news.iprimus.com.au>

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:uvgi1buhf.fsf_at_verizon.net...

> On 28 Sep 2001, s_poppel_at_yahoo.com wrote:
>
> > Can the ORACLE database automatically disconnect from an
> > application that has been sitting idle for many hours or does
> > this have to be set up using the timer initiated disconnect
> > through Net8 configuration ?
>
> You can manage this through a profile.
>
> idle_time is the parameter to care about when creating or
> altering the profile you are going to use.

Don't disagree, other than to say that resource profiles were invented in Oracle 7, and are a rather blunt instrument -by which I mean that if the Server Process is lying idle for the specified number of minutes, the session is simply disconnected. Never mind what the Server process was waiting for (perhaps a "commit" of that million row insert?!), it is simply (and brutally) disconnected, and whatever it had been doing is rolled back (thus chewing up some resources!)

So, just use it with care, and don't be too aggressive about setting an idle time.

If you've got 8i, a rather subtler approach suggests itself: knock up a script to determine the idle time of sessions every so often, and use Resource Manager techniques to shunt an offending session into a low-resource group. No disconnects, no unwanted rollbacks. Just a thought, anyway.

Regards
HJR
>
> Then, alter your application's user to have this profile.
>
> Here is documentation on managing resources through profiles.
>

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76956/users.htm#1148
>
> Here is documentation on creating how to create profiles.
>

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a85397/statem21.htm#2065932
>
> --
> Galen Boyer
> I have nightmares about Tinky Winky beating me with his red bag.
Received on Sat Sep 29 2001 - 21:56:05 CDT