Re: Performance issue in Oracle8i
From: Frank <fbortel_at_home.nl>
Date: Wed, 22 May 2002 20:16:22 +0200
Message-ID: <3CEBE076.5010301_at_home.nl>
Date: Wed, 22 May 2002 20:16:22 +0200
Message-ID: <3CEBE076.5010301_at_home.nl>
Raffa Edwards wrote:
> The phrase "migrated to Oracle8i" implies that you are unaware of the change
> in the optimizer from version 7 to 8i. Newer version of Oracle are cost
> based
> not rule based.
>
<snip>
And it implies the Oracle 8i performance steps (post-migration steps in the book) have not been performed.
Rule of thumb: every major oracle version wants twice as much memory Received on Wed May 22 2002 - 20:16:22 CEST