Hi Mark, I'm curious with your procedure or script that using 'open (cursor);' clauses. please check whether you forgot to close the opening cursor. just a curious.
Rgrds, Sony > -----Original Message----- > From: Mark Richard [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 6:14 AM > To: Multiple recipients of list ORACLE-L > Subject: ORA-1000 - How to trace culprit > > Hi, > > We're currently getting a lot of ORA-1000 errors (max open cursors > exceeded) on Oracle 8.1.7.4. > > I tried looking at v$open_cursor and saw the following: > > 1* select sid, count(*) from v$open_cursor group by sid order by > count(*) > desc > SQL> / > > SID COUNT(*) > ---------- ---------- > 9 43 > 8 38 > 11 38 > 27 38 > {snip} > > This seems inconsistent with our open_cursors parameter of 255. > > Is there something I'm doing wrong, or something else I can check to try > and determine if this parameter is set incorrectly perhaps, or am I > looking > at v$open_cursor incorrectly. Part of the difficulty is that our > application connect to the database via 24 database connections - all > sharing load. My understanding though is that each of the 24 connections > should allow 255 cursors to be open and our highest connection is only > showing 43 in v$open_cursor. > > Any suggestions are greatly appreciated as people are getting anxious. > > Regards, > Mark. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > >>>>>> > Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message > (or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender > by reply e-mail or by telephone on (61 3) 9612-6999. > Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > >>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).