Re: Killing active session

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 Jan 2002 18:43:04 +0100
Message-ID: <l73e4uskckmiv1klh37tgq0a6m4teaa49o@4ax.com>

On Thu, 17 Jan 2002 16:49:19 +0200, "Sergiy Dubovik" <Sergiy.Dubovik_at_reach-u.com> wrote:

>Hi All
>
>How can I kill all active sessions in the database using console?
>Solaris, oracle 8.1.6.
>
>Thanks.
>
>Sergiy
>

alter system kill session 'sid,serial#'
where sid and serial# are parameters to be retrieved from v$session. Of course a kill -9 also works.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 17 2002 - 11:43:04 CST