Re: Weird database hanging -- OPEN_CURSORS
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: don@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 20 Sep 2007 09:51:21 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Re: Weird database hanging -- OPEN_CURSORS
