RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

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
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net]
> 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" <Rich.Jesse_at_qtiworld.com>
> > Date: 2003/08/07 Thu PM 04:14:23 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > 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
> > rjesse_at_qtiworld.com 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
> > > rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).