Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer
Date: Tue, 26 Feb 2008 20:16:46 -0800
There is a new Oracle White Paper on OTN that discusses 9i to 10g upgrades, specifically regarding what to expect from the Optimizer. I highly recommend reading it if you are planning 9i to 10g upgrades or recently have performed upgrades. It contains many of the differences and changes in default behavior of Optimizer and Statistics related functionality.