Re: Looking for notes / examples where OFE doesn't help
- From: Mauro Pagano <mauro.pagano@xxxxxxxxx>
- To: "Hemant-K.Chitale@xxxxxx" <Hemant-K.Chitale@xxxxxx>
- Date: Thu, 27 Nov 2014 07:13:07 -0500
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@xxxxxx>
> 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.
Other related posts:
