Yes, V$OPEN_CURSOR is instance-wide, but each row in the view sure looks like it can be attributed to a specific session via SADDR/ID/USERNAME. And the count of those rows for each session doesn't match the corresponding row/attribute in V$SESSSTAT.
Erm, I'll leave off the product name here since this is the only DB problem I've seen with it, but I will say that it's a bug tracking package. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 07, 2003 3:29 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR > > > v$open_cursors is all open cursors in the instance > > v$sesstat is just open cursors in the session. > > what 3rd party product is that? is it cross platform? Ill > make sure not to buy it. really bad code to get too many open > cursors. > > > > From: "Jesse, Rich" <[EMAIL PROTECTED]> > > Date: 2003/08/07 Thu PM 04:14:23 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR > > > > 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).
