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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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: [EMAIL PROTECTED] > > 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: [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.com > -- > Author: Ji, Richard > INET: [EMAIL PROTECTED] > > 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: [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.com -- Author: Ron Yount INET: [EMAIL PROTECTED] 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: [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).
