Re: optimizer_features_enabled
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 19 Aug 2004 22:00:11 -0600
I have not done exhaustive tests with that parameter, but based on my
experience and from what I read from other people on newsgroups I have the
impression that it is only certain features which get disabled when
backdating optimizer_features enabled (just as the name suggests). You
don't get total 8.1.7 behaviour by setting optimizer_features_enabled =
8.1.7. New algorithms and heuristics appear to be unaffected. But I could
be wrong.
There is a metalink note that explains which features are enabled based on
which setting.
At 07:23 PM 8/19/2004, you wrote:
>Hi,
>
>I have a question around the
>optimizer_features_enabled parameter. If we set this
>parameter to 8.1.7 in a 9.2 database does the RDBMS
>kernel use 8.1.7 optimization algorithms only or does
>it use the 9.2 optimization algorithms but limit the
>CBO to only using 8.1.7 CBO features?
>
>Any clarification on this would be much appreciated.
>
>Regards,
>
>Mark
Regards
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
