Gavin -
This topic came up a few weeks ago on this list. It that case the Oracle
limit being reached was the number of processes. The answer was that
"connection pooling is configured in weblogic properties". The three
parameters to review are: initialCapacity, maxCapacity, capacityIncrement.
Separately I am sending you the document where I captured the entire
discussion. You can also find documents at http://www.weblogic.com.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, July 29, 2002 2:38 AM
To: Multiple recipients of list ORACLE-L
Hi everyone,
I am running EJB under weblogic 5.1 jdbc 2.0, and
when I last checked the database the number of open cursors was 564. I know
8.1.7 has a cap of 750 open cursors after which the db will crash. Since
this is the first time I have faced this problem I would be grateful if
anyone could point out what could be the possible areas that could cause
this problem ( other than the logical one of not closing cursors once they
have been opened and used !).
any help here would be appreciated.
thank you,
Gavin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gavin D'Mello
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
