FreeLists / oracle-l / Re: Meaning of v$sqlarea.users_opening

[Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>]

"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 

--
http://www.freelists.org/webpage/oracle-l