Re: Kill all user on 7.2 db

Erik,
I too am an entry-level DBA, but I have read up on Oracle's documentation on killing an user. I couldn't find one that kills all the users that are logged in, but maybe if you wrote a script that selects the Session id, Serial Number from v$session then kills the user by it's session id, it would work?

ALTER SYSTEM
KILL SESSION 'integer1, integer2'

where: KILL SESSION     terminates a session
              interger1                 specifies the user SESSION ID
              interger2                 specifies the user serial number

Good Luck to you as you follow down the Path of becomming an Oracle Expert.

Satar Naghshineh
SatarNag_at_aol.com

>Hello all,
>
>I got a small question. I'm not that good at oracle because i'm a
>starting DBA. I'm trying to make a endofday script sthat will do
>severall actions on my DB at the end of a day. But before that i want
>to kill all the users who still have a session running. Is there a way
>to do this or do i have to bring the Db down and up.
>
>PLease help me !
Received on Mon Aug 11 1997 - 00:00:00 CDT