Re: Upgrade and Execution Plans

From: Steve Harville <steve.harville_at_gmail.com>
Date: Thu, 07 Apr 2016 15:55:16 +0000
Message-ID: <CAGd4=DToEj9Jx2-Ke_0m0SJE=VTA0QB0rYLjtT5sW8HYdWh0dQ_at_mail.gmail.com>

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:55:16 CEST