Tuesday, February 14, 2012

Upgrading to 11g: Optimizer Changes

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: