Re: max open cursors exceeded

From: elain he <elainhe_at_hotmail.com>
Date: Tue, 21 Oct 2003 17:44:26 -0800
Message-ID: <F001.005D3E6E.20031021174426@fatcity.com>

Hi Craig,
Yup. The application was written in Java using JDBC. Could you kindly email me the tool you mentioned? At this point, I could not figure out the cause of ora-1000.

Thanks!

elain

>From: Craig Munday <cmunday_at_bigpond.net.au>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: max open cursors exceeded
>Date: Tue, 21 Oct 2003 05:39:25 -0800
>
>Hi,
>
>Is your application written in Java using JDBC? I've seen ORA-1000 mostly
>with Java applications because developer's tend to not close ResultSets
>explicitly. Of course it can occur with other environments too. Anyway, I
>have a tool that can help you find the cause of the ORA-1000 if you're
>using JDBC.
>
>Cheers,
>Craig.
>
>
>At 08:39 AM 20/10/2003 -0800, you wrote:
>>Hi,
>>I'm trying to troubleshoot ora-1000 (max cursors exceeded) for an
>>application. When I ran the following query on the SID(192),
>>
>>select hash_value ,count(*)
>>from v$open_cursor
>>where sid=192
>>group by hash_Value
>>having count(*) >1;
>>
>>HASH_VALUE COUNT(*)
>>---------- ----------
>>670480087 5
>>563605149 3
>>1016653255 10
>>2005317811 3
>>
>>hash value: 1016653255 is a simple SQL statement- select sysdate from
>>dual;
>>
>>the results returned hash_values with counts as high as 10. I understand
>>that even if cursors are closed, they are still cached in server memory
>>and will still show up in v$open_cursor. I do not understand why there are
>>duplicate sql statements in v$open_cursor for the SID. Does that mean that
>>Oracle is not reusing the cursor for whatever reasons and thus opens new
>>ones? If that is true, what could be the reasons that 'select sysdate from
>>dual' could not be reused?
>>
>>Thanks.
>>
>>elain
>>
>>_________________________________________________________________
>>Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.
>>http://join.msn.com/?PAGE=features/es
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author: elain he
>> INET: elainhe_at_hotmail.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).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Craig Munday
> INET: cmunday_at_bigpond.net.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).

---

See when your friends are online with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: elain he
  INET: elainhe_at_hotmail.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).

Received on Tue Oct 21 2003 - 20:44:26 CDT