Re: Killing idle user processes ?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/01/09
Message-ID: <6953h9$p0f$1@hermes.is.co.za>#1/1

Glenn Berry wrote in message <34B4FDEC.B436D932_at_gb-data.demon.co.uk>...

>> 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';

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

Er..don't tell me that there are Oracle DBAs without a god complex! :-)

But you right, the ALTER PROFILE is better, but still if we zap all the users then we won't have all these damn support problems...

;-)
Billy
(a firm believer in a userless IT/IS industry) Received on Fri Jan 09 1998 - 00:00:00 CST