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 -> Sessions Won't Die When Killed

Sessions Won't Die When Killed

From: Tim Romano <tim_at_ot.com>
Date: Thu, 20 Aug 1998 17:50:29 -0400
Message-ID: <35DC9A25.A78F63F4@ot.com> 





We received this error:



"unable to make connection ORA-00020: maximum number of processes
(%s) exceeded"



(Why "%s" ? should there be a number here?)



When I attempt to kill the sessions:



ALTER SYSTEM KILL SESSION 'SID,SERIAL#'


Oracle returns:



SYSTEM ALTERED


But when I list v$session afterwards, the "killed" sessions are
still there. Any suggestions or hints  on why these sessions are
so persistent would be appreciated. Also, how to increase the
number of processes?



Thanks,


Tim





Received on Thu Aug 20 1998 - 16:50:29 CDT












Original text of this message













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