Re: Urgent problem : Plz help
Date: Thu, 19 Mar 2009 10:25:06 -0400
Message-ID: <C596F488843C45FAB3B351C2DA7C674B_at_gmei>
Yes, increase processes in init.ora is the way to go (as least as temp measure). But I think you need to figure out where these new processes come from, Keep querying V$session might give you some idea. If the old value 250 which I think is the default worked before then you want to scream back to developers what changes they made to cause this. They need to fix their code. Hope this helps.
Guang
www.eversave.com
- Original Message ----- From: Khan, Muhammad S To: Oracle L Sent: Thursday, March 19, 2009 9:58 AM Subject: Urgent problem : Plz help
Environment: Oracle 9.2.0.6 on SUSE linux 9 64-bit
This problem happened today when our users started screaming about errors at the production database. I tried connecting the database through client and got the error
ORA-00020: maximum number of processes (%s) exceeded
I checked the value of the parameter PROCESSES which was 250. I set it to 300 and after the restart, I monitored the sessions and noticed the continuous increase in the number in the sessions where username is null. I think we may regard these as the orphan sessions. Surprisingly, the count for these sessions kept on increasing till it hit 300 and the clients started getting the same error.
Considering the RAM, I've set the value of PROCESSES to 500 which may be the highest value I can set here. But I again notice that the count of these sessions with null username is continuously increasing. I doubt it will hit the max limit again.
We don't have Connection pooling or MTS. Can anyone please give me the solution, its highly urgent!!!
Thanks.
Khan
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 19 2009 - 09:25:06 CDT