Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance after 9i migration on Windows

Re: Poor Performance after 9i migration on Windows

From: Christian Antognini <christian.antognini_at_trivadis.com>
Date: Fri, 9 Jul 2004 06:01:12 +0200
Message-ID: <40ee1889@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

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

Received on Thu Jul 08 2004 - 23:01:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US