Re: Kill sessions

On 8 May 1997 14:53:46 GMT, afc_at_afc.com (afc) wrote:

>Hi all,
>
>Does anybody have a script that will kill all sessions in Oracle?.
>
>Cheers.
>Chris
>cookcs_at_logica.com

This is a self generating script -

select 'alter system kill session'
||''''||sid||''''||','||''''||serial#||''''||';' from v$session where username is not null;

You will try to kill yourself but Oracle won't let you.

A much easier way to kill all sessions is to shut down immediate;

Sheilah Scheurich
DBA Received on Thu May 08 1997 - 00:00:00 CDT