Re: Looking for notes / examples where OFE doesn't help
From: <coskan_at_gmail.com>
Date: Thu, 27 Nov 2014 12:57:49 +0400
Message-ID: <20141127085749.6635669.50764.4783_at_gmail.com>
Looking for notes / examples where OFE doesn't help
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 27 2014 - 09:57:49 CET
Date: Thu, 27 Nov 2014 12:57:49 +0400
Message-ID: <20141127085749.6635669.50764.4783_at_gmail.com>
I had similar issues back in 3 years ago. I think this was due to some optimizer fixes were not changing their value with ofe difference. You need to check before after imiges of optimizer parameters and optimizer fixes when you are doing the tests
Regards
From: Chitale, Hemant K Sent: Thursday, 27 November 2014 12:33 To: ORACLE-L Reply To: Hemant-K.Chitale_at_sc.com Subject: Looking for notes / examples where OFE doesn't help |
I am looking for notes and/or examples that show that, after an upgrade and execution plan changes, even resetting OFE doesn’t always help. That is : OFE set to the previous version doesn’t guarantee that execution plan and runtime will be exactly as it was in the earlier version.
One example I find is at http://jonathanlewis.wordpress.com/2014/11/03/upgrades-4/
Any more would help me.
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.