Re: max open cursors exceeded

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