Re: jdbcadaptor max number of processes (100) exceeded
Re: jdbcadaptor max number of processes (100) exceeded
- Subject: Re: jdbcadaptor max number of processes (100) exceeded
- From: Art Isbell <email@hidden>
- Date: Wed, 11 Feb 2004 15:16:29 -1000
On Feb 11, 2004, at 2:38 PM, Robert A. Decker wrote:
I'm setting up a number of instances of our app on an xserve. I can't
start up any more processes because I'm seeing:
com.webobjects.jdbcadaptor.JDBCAdaptorException: ORA-00020: maximum
number
of processes (100) exceeded
This is at around... 15 applications or something like that.
How do I get around this? I've just started looking through
com.webobjects.jdbcadaptor.* but there's a lot in there...
This is an Oracle error message that's being passed on by the JDBC
adaptor. Oracle seems to be complaining that the maximum number of
Oracle processes (connections?) has been exceeded. Oracle is very
configurable, so the maximum number of processes can likely be
increased. But doing so probably has a cost.
Just doing the math, it appears that each WebObjects instance opens
several Oracle connections. If you are opening an Oracle connection
for each WebObjects session, maybe you can avoid doing so.
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.