| Max number of processes ora-00020 message [message #338748] |
Tue, 05 August 2008 20:54  |
evergrean
Messages: 15
Registered: February 2008
|
Junior Member |
|
|
We are getting ora-00020 message (ORA-00020: maximum number of processes (%s) exceeded) when trying to connect to our Oracle 9i database instance using OEM. Most connections are from server sides such as ColdFusion and JSP/Servlets.
The server sides give me back similiar message:150 maximum number of processes exceeded.
I googled the error message and it says to find what user is causing the problem. I used v$session but didnt find any user keeping the connection open.
Please advise what could be causing this message and how can it be fixed?
[Updated on: Tue, 05 August 2008 21:00] Report message to a moderator |
|
|
|
| Re: Max number of processes ora-00020 message [message #338753 is a reply to message #338748] |
Tue, 05 August 2008 21:00  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above.
>I used v$session but didnt find any user keeping the connection open.
Post your query & results returned.
>Please advise what could be causing this message and how can it be fixed?
using sqlplus
SQL> SELECT MACHINE, COUNT(*) FROM V$SESSION GROUP BY MACHINE;
Post results from above using <codetags> as describe in Posting Guidelines above
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
