Re: Looking for notes / examples where OFE doesn't help

From: Mauro Pagano <mauro.pagano_at_gmail.com>
Date: Thu, 27 Nov 2014 07:13:07 -0500
Message-Id: <6F9098F2-A63E-443B-8819-DCC508B33EB9_at_gmail.com>

I don't have any example handy but any CBO fix that is not under a fix_contol (ie. fix for wrong result bugs or ora-600/7445) would not be disabled by an older OFE and so if such fix is responsible for a plan change then changing OFE param will not revert to the old plan

Sent from my iPhone

> On Nov 27, 2014, at 3:32 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com> wrote:
>
> 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-l

Received on Thu Nov 27 2014 - 13:13:07 CET