Looking for notes / examples where OFE doesn't help
From: Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
Date: Thu, 27 Nov 2014 16:32:01 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB602B6DAC2_at_HKJUMXMB103B.zone1.scb.net>
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.
Date: Thu, 27 Nov 2014 16:32:01 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB602B6DAC2_at_HKJUMXMB103B.zone1.scb.net>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 27 2014 - 09:32:01 CET