Re: Database time out utility

No need for a utility. You can create resource profiles (and have been able to do so at least since Oracle 7).

Create profile bootofflazyuser limit
idle time 60;

Alter user scott profile bootofflazyuser;

You need, however, to set the init.ora parameter RESOURCE_LIMIT to be TRUE. (Though, at least in 8i, that parameter can be set dynamically with the 'alter system' command).

After that, Scott will be summarily disconnected from the database whenever his server process has been sat there doing nothing for an hour.

Alternatively, investigate the use of Multithreaded Server configuration.... that way, an idle server process simply whizzes back to the submitted jobs queue, and starts working on behalf of someone else. An excellent way of keeping processes busy, regardless of what your users are doing.

Regards
HJR "Revelant" <revoo_at_attbi.com> wrote in message news:3tja8.39888$fK1.4090930_at_rwcrnsc54...
> I am trying to find a utility to find out who has a port open to the
> database and has not done anything in it for say an hour or more. After
what
> ever amount of time, I can have the program disconnect them from the
> database to free up the license. Is there any such utility that someone
can
> point me too?
> Thanks in advance
>
>
Received on Tue Feb 12 2002 - 21:35:56 CST