Oracle-L: RE: open cursors problem

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 29 Jul 2002 06:08:21 -0800
Message-ID: <F001.004A4805.20020729060821@fatcity.com>

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.
dwilliams_at_lifetouch.com

-----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: gavin_d_at_tis.co.in

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------