Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Kill Sessions ask !

Kill Sessions ask !

From: Christian MERCK <cm_at_sdv.fr>
Date: Mon, 14 May 2001 11:27:42 +0200
Message-ID: <9do9r4$b4p$1@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 - 04:27:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US