Re: Risk of RULE mode in 10g+

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 15 Mar 2010 14:34:37 -0500
Message-ID: <ad3aa4c91003151234g479a8177nd26c5c91583d81dd_at_mail.gmail.com>

I think the rule hint still works, even if the RBO is no longer available.

On Mon, Mar 15, 2010 at 2:29 PM, Goulet, Richard <Richard.Goulet_at_parexel.com
> wrote:

> Jeffrey,
>
> OH Dear, I'll try to find the url that says this for you, but in 10g
> the rule based optimizer isn't deprecated, it's dead period. You can put
> rule in there all you want, but it will run in cost mode. Isn't suppose to
> cause problems with the result set that I've heard of, nor does it cause a
> problem with executing the sql.
>
>
> *Dick Goulet***
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jeffrey Zollars
> *Sent:* Monday, March 15, 2010 3:22 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Risk of RULE mode in 10g+
>
> We are upgrading an application to the current version and also upgrading
> the DB version from 9i to 10g. The application code has several bits of code
> that are explicitly setting RULE mode. One in a configuration table that can
> be updated. Second, in several hints coded in SQL statements which cannot be
> easily changed.
>
> I have provided Oracle documentation to the application vendor showing that
> RULE mode is desupported in 10g+ versions. They were skeptical to say the
> least.
>
> I had thought that I'd seen stronger warnings that RULE mode could actually
> generate incorrect result sets when running queries. I have searched but
> could not find those warnings now. I am trying to make a case to request the
> application vendor to go back and modify the code before we update to the
> current version of the application on Oracle 10.2.0.4 version. I'm concerned
> about the integrity of the result sets.
>
> I am wondering if anyone knows of or can provide a link to the warning that
> result sets may be incorrect in 10g+ using RULE mode.
>
> Thanks,
> Jeff
>
> --
> J. A. Zollars
> ZollarJA_at_GMail.com
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Mon Mar 15 2010 - 14:34:37 CDT