| maximum number of processes exceeded [message #332104] |
Mon, 07 July 2008 09:16  |
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
|
Senior Member |
|
|
i'm using oracle 9i database and application server is also oracle 9i application server,my main problem is when my application is busy with many processes, sunddenly i got error "maximum number of processes exceeded" and my all users get errors and they will thrown out from application, to resolve this i have to restart my apps server instance. i am trying to find reasons of this problem but i consfused when query on v$session,$process & v$sqltext. every time i gets different queries in inactive sessions. there are so many sessions available in v$session with the status 'INACTIVE'. on the other hand in v$process process is available but i cant find query from v$sqltext related to above process's hash_value. my processes limit is set to 150.i'm not too much familier with java coding. i would like to know that this problem is with database side, application server side or application coding side?
Chintan Patel
[Updated on: Mon, 07 July 2008 09:19] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: maximum number of processes exceeded [message #332133 is a reply to message #332104] |
Mon, 07 July 2008 10:29  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
> my all users get errors and they will thrown out from application,
I SERIOUSLY doubt this accurately reflects reality.
I suspect that previously connected users stay connected.
Users requiring a new connection, fail to get connected.
Since we have no idea about the application running on the app. server(s), we don't have enough information to guess at a "long term" solution.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
