Home » RDBMS Server » Performance Tuning » Maximum number of oracle processes (Oracle 10g)
Maximum number of oracle processes [message #281440] Fri, 16 November 2007 21:42 Go to next message
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 #281443 is a reply to message #281440] Fri, 16 November 2007 22:14 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Check the alert log file of your database for more information. You have not specified which Oracle version you are using.

Nand
Re: Maximum number of oracle processes [message #281444 is a reply to message #281440] Fri, 16 November 2007 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>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?
By simply
SELECT COUNT(*) FROM V$SESSION.
It sounds like you've been changing initSID.ora parameters & rebooting.
The alert_SID.log file should then conatin a line like:
License high water mark = 24

If this value tracks the changes made for number of sessions,
which I am 100% certain it will, then you have proof the root cause is the application (ab)using the database.

Let me guess, the front end application is written in Java.
Am I correct?
Re: Maximum number of oracle processes [message #281760 is a reply to message #281444] Mon, 19 November 2007 04:37 Go to previous messageGo to next message
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).

Re: Maximum number of oracle processes [message #281849 is a reply to message #281440] Mon, 19 November 2007 09:12 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
java applications are known to open connections & NEVER close them.
Fix the JAVA code to properly connection pool.
Previous Topic: Statspack question
Next Topic: Another question related to Statspack
Goto Forum:
  


Current Time: Fri Dec 09 17:27:27 CST 2016

Total time taken to generate the page: 0.27316 seconds