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

From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 26 Feb 2008 20:16:46 -0800
Message-ID: <a9c093440802262016k1f27ae1dpd9ba3ab3e6db4783@mail.gmail.com>

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.




Greg Rahn

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 26 2008 - 22:16:46 CST

Original text of this message