Re: Poor Performance after 9i migration on Windows

Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.07.09.04.22.16.654215_at_sbcglobal.net>...
> On Fri, 09 Jul 2004 02:39:10 +0000, Kalle wrote:
>
> >
> > Are there any general tips what to check after migration, especially
> > from init.ora -parameters...
>
> Yes. Tune your applications. Tuning spfile$ORACLE_SID.ora will not give
> you more then 2-3%. You can also use method "C", which is in essence this:
> you get all of your hit ratios to predetermined values and declare that
> the instance is performing well. Any statement to the contrary should be
> ignored and suppressed by the large quantities of "DBA lingo". Method "R",
> on the other hand, requires reading. Quite a bit of it, actually.

Have you updated statistics? Have you ran a sql trace on any of the poor performing queries/applications? I would start there. Start taking stats pack snapshots, that may help in giving you a clue on the performance bottleneck.

HTH,
Pete's Received on Fri Jul 09 2004 - 07:44:56 CDT