Re: Poor Performance after 9i migration on Windows

From: maniek <maniekpozioma_at_poczta.onet.pl>
Date: Sat, 10 Jul 2004 02:44:56 -0700
Message-ID: <ccndt4$k6v$1@news.onet.pl>

Kalle wrote:
> Hi all,
>
> 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...
>
> All help appreciated
>
> km
>

maybe there is a problem with "bitmap plans", hidden parameter _b_tree_bitmap_plans
has been changed from 8i (false) to true, so try to change this to false
or maybe your PGA_AGGREGATE_TARGET is to small or ???

maniek Received on Sat Jul 10 2004 - 04:44:56 CDT