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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: too many session open and you can't log in?

Re: too many session open and you can't log in?

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 15 Mar 2007 09:22:56 -0400
Message-ID: <BAY103-DAV1609D98F1A0F7B50D2A19A6720@phx.gbl>


I've had this happen a few times. Usually the result of a bad plan run amok. You can't even log in to see what the problem is. kill -9 should do the trick. It's alter system I find that's unreliable. I usually grep on the server for LOCAL=NO (If I know it's an application issue), awk out the processid and kill -9 the whole bunch. Put the database in restricted mode, log back on, take off restricted mode and monitor what's causing the problem.

Mike

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 15 2007 - 08:22:56 CDT

Original text of this message

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