RE: What is the OEM open cursor method really reflect??

Great reference, Pete!  

While few should mess with the params other an what ADDM suggests, READING this paper would be a big leg up for a lot of folks if they want to understand a bit more of what is going on.  

I see JB is on the contributor list, so it is probably accurate down to the last split hair! (that is a compliment; don't take it any other way, JB)  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Sharman
Sent: Thursday, July 07, 2016 2:50 PM
To: oracle-l_at_freelists.org
Subject: RE: What is the OEM open cursor method really reflect??  

Folks  

There was an email from Chris King with the above title in it which I accidentally deleted and an Outlook bug is showing me incorrect content for the body of that email in my Deleted Items folder so now I can't see the actual email. L Of course, I could find the email on Freelists but that sounds like too much work. J  

The thrust of the question, though, was what is the use of the OEM metric OPEN_CURSORS. While there is substantial gory detail I could go into, the bottom line is this particular metric dates back to the days when tuning it was thought to be important (in many ways like we once used to worry about that wonderful BCHR!). Though somewhat dated, there is a whitepaper from the Shared Pool dev team that went into the details of how SESSION_CACHED_CURSORS and OPEN_CURSORS worked (it's located here
<http://www.oracle.com/technetwork/database/manageability/ps-s003-274003-106
-1-fin-v2-128827.pdf> if you're really that interested). The bottom line nowadays is that ADDM will report if OPEN_CURSORS is undersized and what value to set it to. So have a look at an ADDM report, set and forget is really the recommendation now. J  

Pete

Oracle logo

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: <tel:+61262924095> +61262924095 | | Mobile: +61414443449 Email: pete.sharman_at_oracle.com Twitter: _at_SharmanPete LinkedIn: au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook  

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

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






(image/jpeg attachment: image001.jpg)