| Maximum number of oracle processes [message #281440] |
Fri, 16 November 2007 21:42  |
anamika901
Messages: 3
Registered: May 2007
|
Junior Member |
|
|
Sir,
For last 2-3 months, we suddenly get 'Got minus one from a read call' error throwing as 'javasqlexception' on our intranet page, which uses asp/jsp as front end and oracle as backend.
Trace file clearly showed 'maximum number of processes exceeded' , so we have increased processes and sessions in init.ora file. But still problem is recurring very often.
We have a doubt that some application is the cause of this, but how to trace it, can you give some hint, how to do it?
Thanks
|
|
|
|
|
|
|
|
| Re: Maximum number of oracle processes [message #281760 is a reply to message #281444] |
Mon, 19 November 2007 04:37  |
anamika901
Messages: 3
Registered: May 2007
|
Junior Member |
|
|
As u correctly said, we got these entries in alert_SID.log
License high water mark = 480
License high water mark = 779
when ever we changed the session entries in initSID.ora. We had 300 sessions, increased to 500 to 800.
All the front end applications are written in Java and ASP (1-2 in Dotnet).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
