Re: Upgrade and Execution Plans

From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Thu, 7 Apr 2016 10:05:33 -0700
Message-ID: <CAEbHM44Ej-YARpS0xdW7W2GmGdR1eL1Rn8ppo9+KkzysjCNSyQ_at_mail.gmail.com>

Are you sure you want *all* of the plans to remain the same? Some may greatly improve with the optimizer upgrade (while others get worse). If you do want them all to stay the same, you can try setting optimizer_features_enable to the current 10.?.?.? version.

On Thursday, April 7, 2016, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote:

> Thanks Steve ..For 10g do u see any other way to do it .
>
> I just found one whitepaper ..Going through it .
>
> Upgrading from Oracle Database 10g to 11g: What to expect from the
> Optimizer
>
>
> http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-upgrading-10g-to-11g-what-to-ex-133707.pdf
>
> Br
> Sumit
>
> On Thu, Apr 7, 2016 at 9:27 PM, Steve Harville <steve.harville_at_gmail.com
> <javascript:_e(%7B%7D,'cvml','steve.harville_at_gmail.com');>> wrote:
>
>> Correction - that was for 11.1 to 11.2 upgrades.
>>
>> On Thu, Apr 7, 2016 at 11:55 AM Steve Harville <steve.harville_at_gmail.com
>> <javascript:_e(%7B%7D,'cvml','steve.harville_at_gmail.com');>> wrote:
>>
>>> I have used export/import in the past to maintain the version 10 plans -
>>> see:
>>> https://docs.oracle.com/cd/B28359_01/server.111/b28274/optplanmgmt.htm#CHDGDICI
>>>
>>>
>>> On Thu, Apr 7, 2016 at 11:46 AM sumit Tyagi <dba.tyagisumit_at_gmail.com
>>> <javascript:_e(%7B%7D,'cvml','dba.tyagisumit_at_gmail.com');>> wrote:
>>>
>>>> Hi Guys ,
>>>>
>>>> One of our client want to upgrade it's legacy 10g database to 11.2.0.4
>>>> . But one concern is how it will impact the
>>>> query execution plans ?
>>>>
>>>> How can we make sure the execution plans remain same . What are the
>>>> different options we have here
>>>>
>>>>
>>>> --
>>>>
>>>> *--*
>>>> *BR*
>>>> *Sumit Tyagi*
>>>> *+91-7829543355 <%2B91-7829543355>*
>>>>
>>>
>
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355*
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 07 2016 - 19:05:33 CEST