entfred wrote:
> We are using Oracle 8.16 on an AIX computer.
> My JDBC java application hangs after a bunch of queries are done by 3
> users.
>
> I went into sqlplus and tried accessing the database and got this
> error:
>
> ERROR: ORA-00020: maximum number of processes (250) exceeded
>
> We had to kill the processes.
>
> I have some questions related to this:
>
> 1. I am using connection pool java code to connect to the database.
> There is a parameter
> that I recently raised, since it appeared that the application was
> hanging. After I raised
> the max connections from 5 to 50, the program ran for several days ok
> until today, when
> we started some "stress testing" (i.e. having more than one person run
> the web program)
> of it. How does one go about figuring out what to set this parameter
> to? I was going to try 25 next and eventually get to somewhere between
> 5 and 50, but obviously 5 is too low and 50 is too high :-)
>
> 2. Is there any way to verify in a Java JDBC program that a connection
> from a connection pool is actually closed?
>
>
> Thanks for any information on the above.
>
> --- entfred
8.1.6? It was a horror story even when it was supported. And that was at
least a decade ago. My recommendation would be to get into a version of
Oracle supported during the current millenium.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed May 10 2006 - 15:58:19 CDT
