Re: Weird database hanging -- OPEN_CURSORS

The init.ora parameter OPEN_CURSORS is for each session -- ie it is a limit on the number of cursors a session may have open concurrently.
At the database instance level, you could have many more cursors open (the limit is your shared_pool and available free space fragments in the shared_pool), most of which would be "open"ed by multiple sessions concurrently.

Hemant
At 01:45 AM Thursday, Don Seiler wrote:
>I'm also seeing this in EM dbcontrol regarding the number of open cursors:
>
>Statistics for Last 24 Hours
>Last Known Value 15743.28
>Average Value 7096.27
>High Value 22405
>Low Value 0
>
>My OPEN_CURSORS parameter is set to 700. I'd like to know how these
>numbers all jive.
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

"First they ignore you, then they laugh at you, then they fight you, then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

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