RE: ORA-1000 - How to trace culprit

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:mrichard_at_transurban.com.au]
> 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: mrichard_at_transurban.com.au
>
> 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: 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.net
-- 
Author: Sony kristanto
  INET: Sony_at_polyfincanggih.com

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: 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).