Init.ora Parameter "OPTIMIZER_FEATURES_ENABLE" Reference Note

Reference Note for Init.Ora Parameter “OPTIMIZER_FEATURES_ENABLE”.

• This note contains links to documentation for the server parameter OPTIMIZER_FEATURES_ENABLE along with any additional “Support / Historical Notes” and “Known Bugs” (if any) which may affect or be impacted by the value of this parameter.

OPTIMIZER_FEATURES_ENABLE Documentation

• 11.1 Online Reference for OPTIMIZER_FEATURES_ENABLE
• 10.2 Online Reference for OPTIMIZER_FEATURES_ENABLE
• 10.1 Online Reference for OPTIMIZER_FEATURES_ENABLE
• 9.2 Online Reference for OPTIMIZER_FEATURES_ENABLE
• 9.0 Online Reference for OPTIMIZER_FEATURES_ENABLE

Summary Version Information

Version	Parameter		Type	Modifiable
11.1.0.7	optimizer_features_enable		STRING	ALTER SESSION ALTER SYSTEM (IMMEDIATE)
11.1.0.6	optimizer_features_enable		STRING	ALTER SESSION ALTER SYSTEM (IMMEDIATE)
10.2.0.4	optimizer_features_enable		STRING	ALTER SESSION ALTER SYSTEM (IMMEDIATE)
10.2.0.3	optimizer_features_enable		STRING	ALTER SESSION ALTER SYSTEM (IMMEDIATE)
10.1.0.5	optimizer_features_enable		STRING	ALTER SESSION ALTER SYSTEM (IMMEDIATE)
10.1.0.4	optimizer_features_enable		STRING	ALTER SESSION ALTER SYSTEM (IMMEDIATE)
9.2.0.8	optimizer_features_enable		STRING	Static
9.0.1.4	optimizer_features_enable		STRING	Static
8.1.7.4	optimizer_features_enable		STRING	Static

Support and Historical Notes for “OPTIMIZER_FEATURES_ENABLE”

 This parameter was introduced in Oracle 8.0.4
 Default value:               For Oracle 8.0.x is 8.0.0.
                              For Oracle 8.1.x is 8.1.x.
                                Example:  For Oracle 8.1.7, default is 8.1.7

Articles:
  Overview of Init.Ora Parameter Reference notes    Note:68462.1

Known Bugs

NB	Bug	Fixed	Description
	829114	8.1.5.1, 8.1.6.0	ENH: CBO can use statistical information for functional predicates
	9202351	11.2.0.2, 12.1.0.0	ORA-904 from SQL involving CONNECT BY
	7524366	11.2.0.1	join predicates are not pushed on INSERT SELECT
	6696221	10.2.0.5, 11.1.0.7, 11.2.0.1	Outline from OPTIMIZER_FEATURES_ENABLE=8.1.7 not used
	7421721	11.2.0.1	Bad cardinality from CHAR col <op> :bind if OPTIMIZER_FEATURES_ENABLE <= 10.2.0.4
	6938368	10.2.0.5, 11.1.0.7, 11.2.0.1	OPTIMIZER_FEATURES_ENABLE “special” value enables bug fixes unexpectedly
	5390907	10.2.0.5, 11.1.0.6	Wrong results if function-based index (Including DESC) are present and OFE<10.2
	4556762	10.2.0.3	CBO does not evaluate all plan permutations / Higher Parse Time
	2143154	9.0.1.4, 9.2.0.2, 10.1.0.2	Dump (in evaopn2) from view merging of semi joins
	1578644	8.1.7.2, 9.0.1.0	Wrong results possible from ORed non-correlated subquery predicates (eg: EXISTS)
	1549991	8.1.7.2, 9.0.1.0	Long parse times for long OR chains when OPTIMIZER_FEATURES_ENABLE>=8.1.6
	773518	8.0.5.2, 8.0.6.0	OERI:KXPARCALLOC1 / dump possible from PQ of outer join

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Init.ora Parameter "_COMPLEX_VIEW_MERGING" Reference Note
2. Init.ora Parameter "_FIX_CONTROL" [Hidden] Reference Note
3. Init.ora Parameter "SORT_MULTIBLOCK_READ_COUNT"
4. ORA-600 quick reference guide
5. PostgreSQL.Essential.Reference
6. DIAG: Alter System Dump Undo – Quick Reference
7. famous summary stack trace from Oracle Version 8.1.7.4.0 Bug Note
8. New Parameter DB_ULTRA_SAFE introduce In 11g
9. How To Set The _TXN_BUFFER_SIZE Parameter For a Streams Apply Process
10. Diff Hidden Parameter between 10g and 11g