Init.ora Parameter "QUERY_REWRITE_ENABLED" Reference Note

查看文章

2009-09-16 15:30

FROM Metalink Doc: 68624.1

Reference Note for Init.Ora Parameter "QUERY_REWRITE_ENABLED".

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

QUERY_REWRITE_ENABLED Documentation

Summary Version Information

Version Parameter Type Modifiable

11.1.0.7 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

11.1.0.6 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

10.2.0.4 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

10.2.0.3 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

10.1.0.5 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

10.1.0.4 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

9.2.0.8 query_rewrite_enabled STRING ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

9.0.1.4 query_rewrite_enabled BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

8.1.7.4 query_rewrite_enabled BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)

Support and Historical Notes for "QUERY_REWRITE_ENABLED"

  This parameter can be altered at session level. It needs to be
  set to TRUE to enable the use of functional indexes (See Note 69492.1)
  and for stored outlines.

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

Known Bugs

NB	Bug	Fixed	Description
	6520370	11.1.0.7	Wrong results from query rewrite when CBO chooses not to use the rewritten query
	6977443	10.2.0.5, 11.2	QSM-1153 query rewrite fails due to the presence of subquery
	7032300	10.2.0.5, 11.2	Query rewrite does not occur (QSM-1263)
	6155146	10.2.0.5, 11.1.0.7, 10.2.0.4.P16	Wrong results from query rewrite with pushed predicate
	6121357	10.2.0.5, 11.1.0.7, 10.2.0.4.P02, 10.2.0.3.P18	OERI[17051] during query rewrite
	6001239	10.2.0.5, 11.1.0.7, 11.2	OERI[kkqsPrepForEventProcessing:1] during query rewrite
	6159522	10.2.0.4, 11.1.0.7, 10.2.0.2.P18	OERI[qkaffsindex3] from ANALYZE TABLE .. ESTIMATE STATISTICS
	5169684	10.2.0.4, 11.1.0.6, 9.2.0.8.P05	Wrong results (all rows no filtering) when rewrite enabled on a view
	5669051	10.2.0.4, 11.1.0.6	Query rewrite may dump in kkqsMMVNormalizeQBC
	5572957	10.2.0.4, 11.1.0.6	Dump (under kkqssjsce) with query rewrite enabled and heavy load
	5570942	10.2.0.4, 11.1.0.6	Query Rewrite causes high parse time with high hits on 'latch: row cache objects' and dc_object_ids / Dump in STRLEN
	5850776	10.2.0.4, 11.1.0.6	OERI[kkqsMMVReAggRewriteExp:notoptfou] from query rewrite
	5660643	10.2.0.4, 11.1.0.6	OERI[kkqsfcsi-1] during query rewrite of SQL with set operator
	5964193	10.2.0.4	OERI[kkqsRewriteCorrCols-1] during query rewrite with ANSI joins
	4259963	10.1.0.5, 10.2.0.1	OERI/dump during query rewrite
	4392110	10.1.0.5, 10.2.0.1	Dump [evagrp] during query rewrite
	4071549	10.1.0.5, 10.2.0.1	ORA-911 from EXPLAIN PLAN with query rewrite enabled
	3949254	10.1.0.4, 10.2.0.1	Dump possible with query rewrite with GROUPING SETS
	3525940	10.1.0.4, 10.2.0.1	OERI[kkqscard-1] possible with query rewrite (ENFORCED)
	2673659	10.1.0.2	Longer parse times / different plans possible with QUERY_REWRITE_ENABLED
	5015257	9.2.0.8, 10.2.0.1	Dump from query rewrite
	4234928	9.2.0.8, 10.1.0.5, 10.2.0.1	Wrong results from query rewrite with anti join
	3919931	9.2.0.8, 10.1.0.5, 10.2.0.1	Wrong results from query rewrite
	3794402	9.2.0.7, 10.1.0.4, 10.2.0.1	Dump during query rewrite with a LIKE operator
	3834163	9.2.0.7	CREATE OUTLINE may dump (kkssct) when QUERY_REWRITE_ENABLED=true
	3404500	9.2.0.6, 10.1.0.3, 10.2.0.1	ORA-604/ORA-1406 with QUERY_REWRITE_ENABLE=TRUE
	2742863	9.2.0.5, 10.1.0.2	Dump (evaopn2) possible using ANSI join
	3056297	9.2.0.5, 10.1.0.2	QUERY_REWRITE_ENABLED=true causes wrong join selectivity estimate
	3042674	9.2.0.5, 10.1.0.2	Wrong results on ANSI object queries / XDB "extract" operations may dump (evaopn2)
	2539213	9.2.0.5, 10.1.0.2	UNION ALL rewrite fails with ORA-1790 or wrong results
	2528839	9.2.0.5, 10.1.0.2	Dump possible using ANSI OUTER JOIN with multiple subqueries
	2799028	9.2.0.4, 10.1.0.2	ENH: Remove Functional Index need for QUERY_REWRITE / QUERY_REWRITE_ENABLED
	2461184	9.2.0.2	OERI:[kkqsfxvc-2] possible during query rewrite
	1895950	9.2.0.1	High parse times for statements with many identical AND predicates when QUERY_REWRITE_ENABLED=TRUE
+	2536041	9.2.0.3, 10.1.0.2	OERI[KKQSADJP-1] with QUERY_REWRITE_ENABLED=TRUE
	1608241	9.0.1.0	PCTAS with a SEQUENCE may crash in kdnini2 if QUERY_REWRITE_ENABLED=TRUE
	2523782	9.0.1.0	Dumps numerous MVIEWS when QUERY_REWRITE_ENABLED=TRUE
	2097926	8.1.7.4, 9.0.1.3, 9.2.0.1	Dump possible from query using Function based index with MVIEW and QUERY_REWRITE_INTEGRITY=TRUSTED
	1790422	8.1.7.3, 9.0.1.0	Dump in QBAOPN possible using TABLE() clause with QUERY_REWRITE_ENABLED
	1528882	8.1.7.1, 9.0.1.0	QUERY_REWRITE_ENABLED=TRUE can cause PARSE to SPIN with long OR chains
	858015	8.1.6.0	Shared pool memory for views higher if QUERY_REWRITE_ENABLED set

类别：oracle database 基础及troubleshooting | 添加到搜藏 | 浏览() | 评论 (0)

姓　名：	*姓名最长为50字节

网址或邮箱：	(选填)

内　容：

验证码：	请点击后输入四位验证码，字母不区分大小写看不清?
	取消回复