Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 USAReceived on Thu Jul 24 2003 - 14:42:17 CDT