Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> V$SESSSTAT stat 3 vs V$OPEN_CURSOR

V$SESSSTAT stat 3 vs V$OPEN_CURSOR

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Thu, 24 Jul 2003 14:42:17 -0500
Message-Id: <26007.339480@fatcity.com>


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
Received on Thu Jul 24 2003 - 14:42:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US