Got a question for the Optimizer team?

If you have an idea for a post you would like to see on our blog please email us


Tuesday, February 26, 2008

Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer

One of the most daunting activities a DBA can undertake is upgrading the database to a new version. Having to comprehend all of the new features and to deal with potential plan changes can be overwhelming. In order to help DBA's upgrade from Oracle Database 9i to 10g a new whitepaper called "Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer" has recently been posted on Oracle Technology Network (OTN). This paper aims to explain in detail what to expect from the CBO when you upgrade from Oracle database 9i to 10g and describes what steps you should take before and after the upgrade to minimize any potential SQL regressions. This is a must read for any DBA planning on upgrading from 9i to 10g in the near future!

1 comment:

Unknown said...

Thanks! I also appreciate the parts on the diff stats. This is a great feature to have back-ported to 10.2.0.4. Thanks again!