Re: Killing idle user processes ?

You can utilize the profile feature to terminate idle sessions after a defined period. For example, you could change the default profile (which all user id's use unless you have defined others) as follows:

ALTER PROFILE DEFAULT LIMIT IDLE_TIME 60; This will have Oracle server terminate connections after 60 minutes of idle time with any user process.

Bert Scalzo

Niels S. Eliasen wrote in message ...
>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".
>+------------------------------------------------------------------------+
>
Received on Thu Jan 08 1998 - 00:00:00 CST