Re: Meaning of v$sqlarea.users_opening
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Dec 2007 20:28:48 -0800 (PST)
"I thought I understood that the query above returns a value of 250 bytes
for each concurrent user for each cursor that the user has open. But the
continuously rising value returned by the query suggests that the database
is experiencing some combination of a continuously rising number of
database connections and/or a continuously rising number of open cursors
per connection. That should not be the case in this database"
I think that "250" is being accounted for library cache lock and pin
structures, which are required for
each cursor being executed by a session. Continuously rising value for
"USERS_OPENING" may be due to sql child cursors or
your "SESSION_CACHED_CURSOR" setting influencing it.
You can also run "select count(distinct kgllksnm) from x$kgllk where
kglnahsh=&hash_value)" to see what is going on.
Thanks,
Sai.
http://sai-oracle.blogspot.com
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
//www.freelists.org/webpage/oracle-l
Other related posts:
