Re: Killing idle user processes ?

From: Glenn Berry <glenn.berry_at_gb-data.demon.co.uk>
Date: 1998/01/08
Message-ID: <34B4FDEC.B436D932@gb-data.demon.co.uk>#1/1

Do NOT do this, a session can be 'inactive' in between queries.

Change the default profile to have an idle time limit.

ALTER PROFILE DEFAULT LIMIT IDLE_TIME 30; This is in minutes and is very useful.

Glenn.

BT and I have a deal:-
I don't speak for them, they don't speak for me.

Billy Verreynne wrote:

> 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';
Received on Thu Jan 08 1998 - 00:00:00 CST