Re: Killing idle user processes ?

Sanjay is right. Oracle will not automatically kill a process that has exceeded its time limit until after the process issues another request for service; at which time Oracle finally checks the time of the previous request from that user, does some math and responds with an out-of-luck timeout message.
You could write a script to periodically query v$session for idle processes and kill them yourself from the O/S. It's ugly, I know, but it also works.

Mary Travis
DBA
EDS "Niels S. Eliasen" <nse_at_lu.se> wrote:

>Hello there
 

> Anyone figured out how to kill off idle user-processes ??
 

>Running more than 300 userprocesses is ok, but I would like to dump off
>all those that just get into Oracle in the morning and then just sits
>there......

>regards/mvh
>+------------------------------------------------------------------------+
>Niels S. Eliasen " ... and all these memories
>mailid: nse_at_ruc.dk are to vanish like tears
>Tel: +45 46 78 60 50 in the rain!"
>Mobile: +45 21 24 65 30 final words from Rutger Hauer
> in "Blade Runner".
>+------------------------------------------------------------------------+

Mary Travis
BellSouth Telecommunications
email: Mary.B.Travis_at_bridge.bellsouth.com Received on Fri Jan 09 1998 - 00:00:00 CST