Re: Meaning of v$sqlarea.users

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

Re: Meaning of v$sqlarea.users_opening