Besides you can try ALTER SYSTEM DISCONNECT SESSION in some cases.
Above destroys the dedicated server process or virtual connection in case of
MTS.
--
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 - 23:03:56 CDT
