There were discussions about this before. You can search the archive for it. v$open_cursor and the statistic "opened cursor current" doesn't always agree. v$open_cursor show cursors parsed and not closed, while the "opened cursor current" shows cursors opened and not closed. v$open_cursor doesn't track for unparsed dynamic cursors so it some times doesn't show all cursors that count toward the max open cursor parameter.
Richard Ji -----Original Message----- Sent: Thursday, August 07, 2003 4:14 PM To: Multiple recipients of list ORACLE-L No takers on this from the perf tuning gurus? Please don't make me open a TAR. Think of the children... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Jesse, Rich > Sent: Thursday, July 24, 2003 3:39 PM > To: Multiple recipients of list ORACLE-L > Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR > > > Hey all, > > We recently had a problem with a 3rd-party app getting > "ORA-1000 max open > cursors exceeded" on their 8.1.7.4 DB. Since OPEN_CURSORS is > set to 500 in > the init.ora -- should be more than generous for a tiny app > on a tiny DB -- > we started looking into how many cursors the app actually has > open at any > given time. > > While investigating this, I see that the number of rows in > V$OPEN_CURSORS > isn't consistent with the value of stat 3 ("opened cursors > current") of > V$SESSSTAT. Of the two processes I looked at, each had a > V$SESSSTAT value > of "3" for stat 3, while the first had a single entry in > V$OPEN_CURSOR and > the second had four. > > Should these values match? I looked on Metalink but was > unable to find any > reference to the relationship between these, other than a > forum article > where the OraSupport person was extraordinarily unhelpful. > > TIA, > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] 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: [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).