Re: Kill Sessions ask !

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Mon, 14 May 2001 16:32:45 +0500
Message-ID: <9doc2i$6ki$1@Services.ktnet.kg>

Hi,
the terminated session row from v$session view is removed after a user attempts to use the session again. And user gets ORA-00028 message then.

Roman Mirzaitov
Brainbench MVP for Oracle Administration www.brainbench.com

"Christian MERCK" <cm_at_sdv.fr> wrote in message news:9do9r4$b4p$1_at_reader1.fr.uu.net...
> 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.
>
>
>
Received on Mon May 14 2001 - 06:32:45 CDT