How to calculate max_open_cursors?
Printable View
How to calculate max_open_cursors?
only developer, know how many cursors opened...
you need change init.ora.... open_cursor = 1000
Recently give ansQuote:
Originally Posted by Nadeem
1- 99.99999% of the time they know nothing.Quote:
Originally Posted by sslobo
2- Nice... based on what?
Very helpfulQuote:
Originally Posted by gauramit1982
You want to set max_open_cursors to a value large enough to run your stuff without issues but not excessively large in order to avoid overhead.
You can monitor your Open Cursors environment running query below...
Code:select count(*) "# Sessions",
round(avg(count(*))) "AVG OpenCursors",
max(count(*)) "MAX OpenCursors"
from v$open_cursor a
group by a.sid;