DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=DHm1mxnBX+Efbh22+tV9UEUCnKjhMBSEB/HB4ATn+F6z0/LZXTHyEdrFcBVMAFlEARaRf7oXFzE02KLl/4+rSyV/mdVcr9YrUf9BMt01XEZmZRe96XzmTkOMDKotNWzXjlOVK1ojGykcKhs5pYuAQUdBTyFkeuTXeWUhnAHy9ts=
Message-ID: <1c1a62990802292042x2a9c2892x758ee2f6b58ff053@mail.gmail.com>
Date: Fri, 29 Feb 2008 20:42:46 -0800
From: "Arul Ramachandran" <contactarul@gmail.com>
To: greg@structureddata.org
Subject: Re: Upgrading from Oracle Database 9i to 10g: What to expect from the Optimizer
Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
In-Reply-To: <a9c093440802262016k1f27ae1dpd9ba3ab3e6db4783@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_16717_19311321.1204346566412"
References: <a9c093440802262016k1f27ae1dpd9ba3ab3e6db4783@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: contactarul@gmail.com
------=_Part_16717_19311321.1204346566412
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@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
>
>
>

------=_Part_16717_19311321.1204346566412
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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&#39;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.<br>
<br>Regards,<br>Arul<br><br>
<br><div class="gmail_quote">On Tue, Feb 26, 2008 at 8:16 PM, Greg Rahn &lt;<a href="mailto:greg@structureddata.org" target="_blank">greg@structureddata.org</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

There is a new Oracle White Paper on OTN that discusses 9i to 10g<br>
upgrades, specifically regarding what to expect from the Optimizer. I<br>
highly recommend reading it if you are planning 9i to 10g upgrades or<br>
recently have performed upgrades. It contains many of the differences<br>
and changes in default behavior of Optimizer and Statistics related<br>
functionality.<br>
<br>
<a href="http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf" target="_blank">http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf</a><br>
<br>
--<br>
Regards,<br>
<br>
Greg Rahn<br>
<a href="http://structureddata.org" target="_blank">http://structureddata.org</a><br>
<font color="#888888">--<br>
<a href="http://www.freelists.org/webpage/oracle-l" target="_blank">http://www.freelists.org/webpage/oracle-l</a><br>
<br>
<br>
</font></blockquote></div><br><br clear="all"><br>

------=_Part_16717_19311321.1204346566412--
--
http://www.freelists.org/webpage/oracle-l