Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Kill Sessions ask !
It will disappear when it will try to contact server next time. If client died it not gonna happen. So take Joe's advice or better yet configure dead client detection (DCD) and Oracle will clean them up. Ideally. There is a bug#1394008 in 8.1.6 and 8.1.7 when DCD does not work with MTS. You might need some patching.
Regards,
Igor.
> 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.
>
>
>