RE: cursor not closing

In the for what it is worth department, I had similiar issues. After the developers knocked themselves out looking for code that was not closing the cursor, I opened a tar:

In a nutshell: yet another "feature" that cursors "even though closed by the session that opened them" remain available.... this is touted as a feature since there may be a session later that could benefit from a previous cursor... this behavior will continue until max_cursors is reached and then you are done...:-(

You can remedy this situation with the _CLOSE_CACHED_OPEN_CURSORS=true init parameter.

If you are interested in more detail... my tar number is: 1921166.995

HTH, -Ron-

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ji, Richard
> Sent: Friday, March 08, 2002 6:23 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: cursor not closing
>
>
> Identify all the codes where ResultSet, Statement are used and make sure
> they are closed after it's done.
>
> -----Original Message-----
> Sent: Friday, March 08, 2002 4:48 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> We have a Application that user JDBC thin client connecting to Oracle
> database.
> It seems like java code is opening the cursor , running some sql but not
> closing
> the cusrsor.
> Now the number of open_cursor reached 3568 .
> Is there any way we can close cursor from sqlplus.
>
> Thanks
> --Harvinder
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
> INET: Harvinder.Singh_at_MetraTech.com
>
> 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: Ji, Richard
> INET: Richard.Ji_at_MobileSpring.com
>
> 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: Ron  Yount
  INET: ronwy_at_swbell.net

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