Re: Kill Sessions ask !

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 14 May 2001 23:16:52 +0800
Message-ID: <3AFFF6E4.2DCA@yahoo.com>

Christian MERCK wrote:
>
> Hi,
>
> I'm using Oracle 8.1.6.
>
> When I kill session with "ALTER SYSTEM KILL SESSION 'nnn,nnn' ", this
> session is marked KILLED but it never disappear from V$SESSION.
> This is a problem because the I have reached the MAX_NUMBER_PROCESS.
> Does anyone know why the sessions marked KILLED don't disappear ?
>
> Thanks in advance.
>
> Christian.

There is also 'alter system kill session ... immediate'

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Received on Mon May 14 2001 - 10:16:52 CDT