Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 0741A19602E7 for ; Thu, 7 Jul 2016 21:27:09 +0200 (CEST) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Thu, 7 Jul 2016 21:27:08 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 01BF6252FF; Thu, 7 Jul 2016 15:27:07 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id zEHjuj0LKQFe; Thu, 7 Jul 2016 15:27:06 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1788B252F1; Thu, 7 Jul 2016 15:26:54 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2016 15:25:32 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 23FE7252C8 for ; Thu, 7 Jul 2016 15:25:32 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id St1naE8o2pDY for ; Thu, 7 Jul 2016 15:25:32 -0400 (EDT) Received: from cpanel.firstlight.net (cpanel.firstlight.net [72.0.157.4]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id D38E623B77 for ; Thu, 7 Jul 2016 15:25:31 -0400 (EDT) Received: from c-65-96-123-158.hsd1.nh.comcast.net ([65.96.123.158]:63193 helo=mwf4500) by cpanel.firstlight.net with esmtpsa (TLSv1:ECDHE-RSA-AES256-SHA:256) (Exim 4.87) (envelope-from ) id 1bLEvU-0000tK-5T; Thu, 07 Jul 2016 15:25:32 -0400 From: "Mark W. Farnham" To: , References: In-Reply-To: Subject: RE: What is the OEM open cursor method really reflect?? Date: Thu, 7 Jul 2016 15:25:19 -0400 Message-ID: <014901d1d885$4e39dd00$eaad9700$@rsiz.com> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_014A_01D1D863.C72A86F0" Content-Language: en-us X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - cpanel.firstlight.net X-AntiAbuse: Original Domain - freelists.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - rsiz.com X-Get-Message-Sender-Via: cpanel.firstlight.net: authenticated_id: mfarnham@rsiz.com X-Authenticated-Sender: cpanel.firstlight.net: mfarnham@rsiz.com X-archive-position: 65486 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mwf@rsiz.com Precedence: normal Reply-To: mwf@rsiz.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l ------=_NextPart_000_014A_01D1D863.C72A86F0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_014B_01D1D863.C72A86F0" ------=_NextPart_001_014B_01D1D863.C72A86F0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Peter Sharman Sent: Thursday, July 07, 2016 2:50 PM To: oracle-l@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 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: +61262924095 | | Mobile: +61414443449 Email: pete.sharman@oracle.com Twitter: @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 _____ ------=_NextPart_001_014B_01D1D863.C72A86F0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Peter Sharman
Sent: Thursday, July 07, = 2016 2:50 PM
To: oracle-l@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 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

3D"Oracle

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

Phone: +61262924095 | | Mobile: = +61414443449 
Email: pete.sharman@oracle.com = Twitter: @SharmanPete  LinkedIn: au.linkedi= n.com/in/petesharma= n
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

 

------=_NextPart_001_014B_01D1D863.C72A86F0-- ------=_NextPart_000_014A_01D1D863.C72A86F0 Content-Type: image/jpeg; name="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7 Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAARAFgDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDp/D2n ReMlu9S1ueWZ1uGiS1WQosCjpwO/vWhqPgvSbKwmurOW4sZ4UMiTrO3yEDPOTyKfqPhWK71CS600 3NjK/wDrZIJjGJD7j196qnwbM5UaheX17bg5aBrokN9R3rJRt01PYdZOXNGpyx/l/TsY1n5XiXVr a51iCabGkiV44iQWIcjIA6561GH0e5ubb/hEYNQj1FbhQWO8Iq5+YPnjpXcW+kQQ+IV1GFDGq2Yg VRwoUHOMVC+hp/wkK6nYF7SQjFwUOEm+q9z70chf1yF7K6VtFfT0aMzxVqI1C/i8Ox3i20JAfULj ftEadkz6tVLTPEz6ZpGraX9pjvLrToWe0mDBvNi7E46le9b+m+HrKztr2G8t/tTXUxknaYBzL6fg Kgu/DGlyz2sljYizkgfcXiQICpGCpHcH0p2lv1MoVaHL7Jq6X59+/l6FbSPB2lalpVtfX809/c3M Ykedp25JGcDB4HtUWtaVZ6HcaBb2EbRI2pAtliS3ynqTTj4OkV3Om3V7Y2zMWWFLkhR9B2+lSXHh KSbTIbae7u5LiO581JmuMsvGOvak1poi1VXtFJ1brXTtdP5aHXPwpI7DNeW2Tya89zfalouqaozT MqiCULHCAfugZHPrXRJ4R1IOpbWNQKgjI+1nkflUl54TWe+ludNkurBpD+9MNwUWQ+uPX3pyvIjD OlQuua7fXXT7tdfITw/otjIlwDoV7pgJXJuJsl8HOBycCitHQdDutLuJJLi9urneuAJpy4H4UU4r Q5K9aftHyyv83+ptx9KcetFFWcz3I/X6U0ffWiikMl/5aD6Uh+830oooEOHemt0/GiiqBDu1R96K KQRHpRRRSJe5/9k= ------=_NextPart_000_014A_01D1D863.C72A86F0-- -- http://www.freelists.org/webpage/oracle-l