When migrating to Oracle to a newer version, there is and will always be an impact on the performance of existing queries. Hence, it is wise to perform a full performance regression test with your software against the new version.
Oracle has published a good white paper which explains the new features of the Optimizer in 11g and lists important pre- and post-upgrade tasks. Check it out here: Upgrading from Oracle Database 10g to 11g: What to expect from the Optimizer.
No comments:
Post a Comment