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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Meaning of v$sqlarea.users_opening

Re: Meaning of v$sqlarea.users_opening

From: Mark Anderson <fnmpa_at_uaf.edu>
Date: Wed, 12 Dec 2007 14:30:50 -0900 (AKST)
Message-ID: <3900.137.229.7.101.1197502250.squirrel@fnmpa.email.uaf.edu>


I can answer my own question (or rather Metalink can). The problem looks like bug 5917099 "V$SQLAREA.USERS_OPENING keeps increasing"

> I can focus my earlier question somewhat. The continuously climbing value
> of sum(250*users_opening) over time is because of a small number of very
> large and increasing values of v$sqlarea.users_opening...

regrets,

Mark

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 12 2007 - 17:30:50 CST

Original text of this message

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