optimizer_features_enabled

From: Mark Burgess <mburgess_nz_at_yahoo.co.nz>
Date: Fri, 20 Aug 2004 11:23:08 +1000 (EST)
Message-ID: <20040820012308.4369.qmail@web51809.mail.yahoo.com>

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

Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Aug 19 2004 - 20:18:47 CDT