Re: Poor Performance after 9i migration on Windows

• Post for FREE via your newsreader at post.usenet.com ****

"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.

Application tuning make only sense if the instance is correctly configured. Or do you want to start adding hints to all queries?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=