Re: Queries slow after Upgrade to Oracle 9i

Go through and compare the init.ora files between both versions.

Try to make them as close as possible to each other until you are happy with the performance.

For example, use some 817 settings in the 9i version until the performance is the same. I remember having issues with pga_aggregate_target being set to high on 9i which made one of my queries run for a lot longer. I stopped using pga_aggregate_target in favour of the old 817 parameters, such as SORT_AREA_SIZE, until I understood more about pga_aggregate_target. I ended up adding it back in but at a lower value and my performance with 9i was then the same if not better.

So, once you have similar performance with the 9i version using older parameters, start replacing the older parameters with 9i parameters while checking performance.

"DB Dude" <DBdude_From_NY_at_yahoo.com> wrote in message news:f65280c4.0411090856.159b34e2_at_posting.google.com...
> We have a query which use take less then a minute on Oracle 817, last
> week we upgraded it to Oracle 9i and it takes 48 minutes. I know these
> are not enough info to ask such question, but all I want to know is:
> Is there any known issue with Oracle 9i.
>
> Thanks
Received on Tue Nov 09 2004 - 19:18:39 CST