Re: Upgrade and Execution Plans

From: Steve Harville <steve.harville_at_gmail.com>
Date: Thu, 07 Apr 2016 15:57:37 +0000
Message-ID: <CAGd4=DQwzg1ooHyiN36D2Ca7oCmALOFC3u6zxn2pWXBh6-1Png_at_mail.gmail.com>

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> 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>
> 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*
>>
>

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

Received on Thu Apr 07 2016 - 17:57:37 CEST