Re: Upgrade and Execution Plans

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Thu, 7 Apr 2016 21:37:48 +0530
Message-ID: <CAFW4NVxmD-DsOMtxDLmXqgQKMKE1q0J=yf2gxe9DtXEHA7ei_Q_at_mail.gmail.com>

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> 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>
> 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 <%2B91-7829543355>*
>>>
>>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

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

Received on Thu Apr 07 2016 - 18:07:48 CEST