MIME-Version: 1.0
In-Reply-To: <CAG+FZag7vF+k5KPOR8fF_mdxPC1Z5r-Ge5rVxt_1g1MG75xXdQ@mail.gmail.com>
References: <CAG+FZag7vF+k5KPOR8fF_mdxPC1Z5r-Ge5rVxt_1g1MG75xXdQ@mail.gmail.com>
Date: Tue, 9 Sep 2014 08:46:22 +0200
Message-ID: <CAJ2-Qb9HN1SmGDUqWMzj=tHrP8+VeW9Y1J42FQ5gQjYr6eyyQA@mail.gmail.com>
Subject: Re: Dataware house DB's Cross Platfarm migration
From: Ls Cheng <exriscer@gmail.com>
To: krishna000@gmail.com
Cc: Oracle Mailinglist <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=20cf307c9d4a21b9c005029c4bc6
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: exriscer@gmail.com
--20cf307c9d4a21b9c005029c4bc6
Content-Type: text/plain; charset=UTF-8

Hi

For your second question, for static reports (non ad-hoc DWH queries) then
you could capture those as a sqlset and transport to the new platform, if
you have perfrmance problems in the new platform you can load the plans
from sqlset to get the old good plan from the previous platform.

Implementing baselines (I suppose you mean SPM) in DWH is not a good or bad
idea, I dont think it is even possible except for the static reports
queries since most queries will be a new query for SPM and you wont able to
evolve them.

For your last question, NO, dont do that. You will be tied to a statistics
set which you have to evolve anyways.

Regards


On Fri, Aug 8, 2014 at 3:52 AM, Bala Krishna <krishna000@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
>

--20cf307c9d4a21b9c005029c4bc6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div>Hi<br><br>For your second question, for sta=
tic reports (non ad-hoc DWH queries) then you could capture those as a sqls=
et and transport to the new platform, if you have perfrmance problems in th=
e new platform you can load the plans from sqlset to get the old good plan =
from the previous platform.<br><br></div>Implementing baselines (I suppose =
you mean SPM) in DWH is not a good or bad idea, I dont think it is even pos=
sible except for the static reports queries since most queries will be a ne=
w query for SPM and you wont able to evolve them.<br><br></div>For your las=
t question, NO, dont do that. You will be tied to a statistics set which yo=
u have to evolve anyways.<br><br></div>Regards<br><br><br></div><div class=
=3D"gmail_extra"><br><div class=3D"gmail_quote">On Fri, Aug 8, 2014 at 3:52=
 AM, Bala Krishna <span dir=3D"ltr">&lt;<a href=3D"mailto:krishna000@gmail.=
com" target=3D"_blank">krishna000@gmail.com</a>&gt;</span> wrote:<br><block=
quote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc=
 solid;padding-left:1ex"><div>Hi Team,</div>
<div>=C2=A0</div>
<div>We&#39;ve a plan to migrate Dataware house Database&#39;s from Aix to =
Linux with Transportable Tablespace as an option. </div>
<div>=C2=A0</div>
<div>Bascally i&#39;m looking forward to measure performance before and aft=
er migration and its implications. </div>
<div>=C2=A0</div>
<div>Requesting you to please answer the below questions , i appreciate if =
there are any pointers to some links etc. </div>
<div>=C2=A0</div>
<div>1. Since the change in system stats how do we make sure that our execu=
tion plans will not change majorly ? and its performance slowness. </div>
<div>2. If there are any executions plans are really performing=C2=A0bad af=
ter migrating , what would be the best options that you suggest to compare =
before and after migrate plans and suggest the best solutions to resolve th=
ose issues ? </div>

<div>3. Implementing baselines is that a good idea ? </div>
<div>4. Exporting and importing stats will help to keep best optimum perfor=
mance? </div>
<div>=C2=A0</div>
<div>Appreciate your response. </div>
<div>=C2=A0</div>
<div>Regards</div><span class=3D"HOEnZb"><font color=3D"#888888">
<div>Bala </div>
</font></span></blockquote></div><br></div>

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