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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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