Re: Killing idle user processes ?

Niels S. Eliasen wrote in message ...
> Anyone figured out how to kill off idle user-processes ??

Create a SQL script that selects the sid and seriial# from all inactive sessions from v$session, spools the output to file and then run the spoolfile thru SQL*Plus. Something like this: SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||'''' FROM v$session WHERE status='INACTIVE';

You probably should add some additional criteria to the above SQL to make sure you're not zapping legit system 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......

If there are that many idle user processes, it means that the application is not being used correctly, or was developed incorrectly IMO. You can also uses the dead connection detection feature of the listener to auto kill Oracle backend processes that remained behind when the front-end processes terminated abnormally.

regards,
Billy Received on Thu Jan 08 1998 - 00:00:00 CST