Re: Why oracle process exceeds the max number ????

goinghome2008_at_hotmail.com (YYgo) wrote in message news:<7e949f76.0211040647.2e24bc59_at_posting.google.com>...
> I'm using WebLogic 6.1 and Oracle 8.1.7.0.0 , and my web application
> always reach the following error:
>
> java.sql.SQLException: ORA-00020: maximum number of processes (150) exceeded

First, I'm assuming that 150 processes is more than sufficient for your site. A particularly busy site that has hundreds of concurrent users might well need a higher limit.

> Are there anybody know how to correct this error ???

If it's a leak, you'll have to inspect your code.

>
> Is there a way to know what code does not close the connection.

Only by looking at the code. Most commonly, the code that closes the connection isn't inside a finally block, so some exception case causes the code to bypass the connection close() statement.

Justin Cave Received on Wed Nov 06 2002 - 01:20:53 CET