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

Thanks for sharing this white paper. This comes out only now, while 10g has been around for 2 years. While the contents of the paper are pretty good and definitely useful for customers who are planning to upgrade, for others who took the step to upgrade earlier had to go through several headaches. I've seen upgrade projects resort to setting o_f_e = 9.2.0 as in certain cases modifying the SQL was not an option. optimizer_secure_view_merging is an interesting feature, had I known about this earlier, I guess it would have saved some grief for a project that I was involved.

Regards,
Arul

On Tue, Feb 26, 2008 at 8:16 PM, Greg Rahn <greg_at_structureddata.org> wrote:

> 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.
>
>
> http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf
>
> --
> Regards,
>
> Greg Rahn
> http://structureddata.org
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l