Re: Dataware house DB's Cross Platfarm migration
Date: Wed, 3 Sep 2014 22:43:27 -0500
Message-ID: <CAEueRAV+MYfprSpYCJwG81ghMJ1oMejbC7kb+BRwC-KK8vr+JQ_at_mail.gmail.com>
Bala,
Real Application Testing (RAT)
<http://docs.oracle.com/cd/E11882_01/server.112/e41481/rat_intro.htm#RATUG101>
was designed to address these exact questions. The two tools in this group
that are relevant to your questions are SQL Performance Analyzer (SPA) and
Database Replay.
Seth Miller
On Thu, Aug 7, 2014 at 8:52 PM, Bala Krishna <krishna000_at_gmail.com> wrote:
> Hi Team,
>
> We've a plan to migrate Dataware house Database's from Aix to Linux with
> Transportable Tablespace as an option.
>
> Bascally i'm looking forward to measure performance before and after
> migration and its implications.
>
> Requesting you to please answer the below questions , i appreciate if
> there are any pointers to some links etc.
>
> 1. Since the change in system stats how do we make sure that our execution
> plans will not change majorly ? and its performance slowness.
> 2. If there are any executions plans are really performing bad after
> migrating , what would be the best options that you suggest to compare
> before and after migrate plans and suggest the best solutions to resolve
> those issues ?
> 3. Implementing baselines is that a good idea ?
> 4. Exporting and importing stats will help to keep best optimum
> performance?
>
> Appreciate your response.
>
> Regards
> Bala
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 04 2014 - 05:43:27 CEST