Re: Poor Performance after 9i migration on Windows

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

Hi Kalle

> we have faced some problems after migrating our database from 8.1.7 to
> 9.2.0.5. Queries are much slower they were before...
>
> Are there any general tips what to check after migration, especially
> from init.ora -parameters...
>
> I am working on windows environment...

The 9.2.0 CBO (and the RBO as well!) behaves differently from 8.1.7. Therefore you should review all parameters related to the optimizer. In addition I suggest you to gather system statistics.

Chris

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

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