-
How to calculate max_open_cursors?
-
With developer
only developer, know how many cursors opened...
you need change init.ora.... open_cursor = 1000
Sandro Lobo
Oracle DBA
www.geocities.com/sslobopt
-
max_open_cursors
Originally Posted by Nadeem
How to calculate max_open_cursors?
Recently give ans
-
Originally Posted by sslobo
only developer, know how many cursors opened...
you need change init.ora.... open_cursor = 1000
1- 99.99999% of the time they know nothing.
2- Nice... based on what?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by gauramit1982
Recently give ans
Very helpful
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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;
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|