«  
  »

Init.ora Parameter "_COMPLEX_VIEW_MERGING" Reference Note

作者: Maclean Liu , post on September 12th, 2009 , English Version
【本站文章除注明转载外，均为本站原创编译】
转载请注明：文章转载自: Oracle Clinic – Maclean Liu的个人技术博客 [http://www.oracledatabase12g.com/]
本文标题: Init.ora Parameter "_COMPLEX_VIEW_MERGING" Reference Note
本文永久地址: http://www.oracledatabase12g.com/archives/init-ora-parameter-_complex_view_merging-reference-note.html

Reference Note for Init.Ora Parameter “_COMPLEX_VIEW_MERGING”.

  • This parameter is a hidden (underscore) parameter
    Such parameters should only ever be set under the guidance of Oracle Support.
    Clearly document why the parameter is set including reference to any SR, Bug or Note

Summary Version Information

Version Parameter Type Modifiable
11.1.0.6 _complex_view_merging BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)
10.2.0.4 _complex_view_merging BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)
10.2.0.3 _complex_view_merging BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)
10.1.0.5 _complex_view_merging BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)
10.1.0.4 _complex_view_merging BOOLEAN ALTER SESSION
ALTER SYSTEM (IMMEDIATE)
9.2.0.8 _complex_view_merging BOOLEAN ALTER SESSION
9.0.1.4 _complex_view_merging BOOLEAN ALTER SESSION
8.1.7.4 _complex_view_merging BOOLEAN ALTER SESSION

Support and Historical Notes for \”$param\”

 Up until Oracle 8i this parameter was a normal visible parameter.
 From 8i onwards the parameter was hidden and made an underscore
 parameter.

 The parameter can be either TRUE or FALSE to enable or disable the
 optimizer code that attempts to merge complex views in a query block.

 The default value of _COMPLEX_VIEW_MERGING depends upon the
 value of OPTIMIZER_FEATURES_ENABLE and is TRUE
 if OPTIMIZER_FEATURES_ENABLE >= 8.0.4 and < 8.1.0
 and it TRUE if OPTIMIZER_FEATURES_ENABLE >= 9.0.0 .
 (Notice it is FALSE for 8.1.X values)
 See Note:62337.1


Known Bugs

NB Bug Fixed Description
2900761 9.2.0.5, 10.1.0.2 ORA-979 from complex view merge of GROUP BY with function (eg: TRUNC/ROUND)
9243893 11.2.0.2, 12.1.0.0 GROUP BY with outer join results not sorted even with ORDER BY clause
8440791 11.2.0.2, 12.1.0.0 Dump on evaopn3 with Scalar Subquery in SELECT list
9800061 11.2.0.2, 12.1.0.0 ORA-979 with correlated subquery in an ORDER BY
7375615 10.2.0.5, 11.2.0.1 Wrong Results (0 Rows) using a Multicolumn function in a View
6963442 11.2.0.1 OERI[KKQVMRRFJCVM: ORIGINAL TABLE NOT FOUND!]
7704811 10.2.0.5, 11.2.0.1 Wrong results from complex view merging
7519687 10.2.0.5, 11.2.0.1 Dump (under subsr3) from complex view merge with distinct subquery
6316585 10.2.0.5, 11.1.0.7 Dump / OERI from complex view merging
6634836 10.2.0.5, 11.1.0.7 Wrong results with view merge and Anti/Semi Join with an aggregate
6276590 10.2.0.5, 11.1.0.7 OERI[qctstc2o1] can occur with RBO
7189447 10.2.0.4.1, 10.2.0.5 Wrong results when view merging applied to query
4741394 10.2.0.3, 11.1.0.6 OERI [12406]/Wrong Results from CONNECT BY query
4493256 9.2.0.8, 10.1.0.5, 10.2.0.2, 11.1.0.6 Wrong result possible from complex view merging of ALL/ANY/[NOT]IN subquery
5059447 10.2.0.5, 11.1.0.6 Wrong Results/ORA-979 with scalar subquery and complex view merging
5921386 10.2.0.4, 11.1.0.6 Wrong result doing view merging and outer join
5017783 10.2.0.5, 11.1.0.6 OERI[qctstc2o1] from cost based query transformation
5642214 10.2.0.4, 11.1.0.6 Wrong results / ORA-1427 from scalar subquery in SELECT list with complex view merging
4637725 10.2.0.3, 11.1.0.6 ORA-918 for remote DML
5603197 10.2.0.4, 11.1.0.6 OERI[qctvco:csform] from UPDATE SQL with a subquery
5183729 10.2.0.4, 11.1.0.6 Dump (kkmins) from insert into a view
5573425 10.2.0.4, 11.1.0.6 Wrong results from subquery unnesting with complex view merge
5128368 10.2.0.4, 11.1.0.6 Dump [kkoeqv] optimizing a query with nested views
8936537 10.2.0.5 Wrong results with Function-Based Indexes,Complex View Merging and UNIQUE access
8488629 10.2.0.5 False ORA-979 from GROUP BY on Views
3583215 9.2.0.6, 10.1.0.4, 10.2.0.1 Dump (qersoRowP) with complex view merging and subquery in SELECT list
3697218 9.2.0.7, 10.1.0.4, 10.2.0.1 Dump (qecvco) from SQL referencing ROWID from a view which is key preserved
3668572 9.2.0.6, 10.1.0.4, 10.2.0.1 ORA-979 when CURSOR_SHARING = force|similar with inline view and GROUP BY
3253133 9.2.0.6, 10.1.0.3, 10.2.0.1 Dump (in evaopn2) from queries using a FUNCTIONAL INDEX with complex view merging
3799129 9.2.0.8, 10.2.0.1 Dump from complex view merging with star transformation
3659827 9.2.0.7, 10.1.0.5, 10.2.0.1 Dump (kkoeqv) when LATERAL view optimized
4178560 9.2.0.7, 10.1.0.5, 10.2.0.1 Complex view merge of DISTINCT view may dump
3953483 9.2.0.7, 10.1.0.4, 10.2.0.1 Complex view merging does not occur for Insert as Select
3188637 9.2.0.6, 10.1.0.4, 10.2.0.1 Wrong result with star transformation and OUTER join
3730394 9.2.0.7, 10.1.0.4, 10.2.0.1 Dump (qerixGetKey) from ANSI SQL with HAVING clause which uses a subquery
4282228 9.2.0.7, 10.1.0.5, 10.2.0.1 Dump executing complex view merged query with subquery and DISTINCT
3249318 9.2.0.8, 10.1.0.5, 10.2.0.1 A query using UNION ALL with multiple mergable views may dump in evaopn2
4482971 OERI[15819] / OERI[qkagby0.4] from PQ slave
5868473 OERI[qkagby0.4] in PQ slave when compiling SQL
2642031 9.2.0.3, 10.1.0.2 ORA-979 from complex view merge of “THE” subquery.
2700474 9.2.0.4, 10.1.0.2 Wrong results from complex view merging of correlated subquery with GROUP BY
2117638 9.2.0.4, 10.1.0.2 ORA-2063 / ORA-1445 possible from outer join over DB link with NULL sensitive predicates
2639311 9.2.0.6, 10.1.0.2 Wrong result with multi join key prefetsh
3302372 9.2.0.6, 10.1.0.2 Dump [qerixgetkey] / OERI[12411] from complex view merging
3230967 9.2.0.6, 10.1.0.2 ORA-979 from complex view merge with TABLE() on outer query block
3269826 9.2.0.7, 10.1.0.2 ORA-918 on complex query with star transformation
3073109 9.2.0.5, 10.1.0.2 Dump / wrong results from complex view merging with inline views
2711380 9.2.0.5, 10.1.0.2 Dump (in evaopn2) using SYS_CONNECT_BY_PATH in an inline view
2942857 9.2.0.5, 10.1.0.2 OERI:12327 from complex view merging
2415893 9.2.0.5, 10.1.0.2 ORA-7445[kkosjt] possible when complex view merging occurs
2453215 9.2.0.2, 10.1.0.2 ORA-7445[vopsvc] selecting ROWID from a complex join view
3352869 9.2.0.6 OERI[kgmgcdty2] possibled from queries using TABLE() functions in views
1838517 8.1.7.3, 9.0.1.1, 9.2.0.1 Wrong result possible from Complex_View_Merging with Functional Index
1360220 8.1.7.3, 9.0.1.0 OERI:9999 / ORA-979 possible from complex view merging
1086489 8.1.6.1, 8.1.7.0 “_complex_view_merging”=true and functional index can dump
1314506 8.1.7.0 ORA-928 possible with COMPEX_VIEW_MERGING and STAR_TRANSFORMATION_ENABLED
1215372 8.1.7.0 Complex view merging with HAVING COUNT(col) may dump
900455 8.0.6.1, 8.1.5.1, 8.1.6.0 Complex view merging of view referencing a ROWID may dump
1028281 8.0.6.1, 8.1.6.0 Wrong results from COMPLEX VIEW MERGING , OUTER JOIN and COUNT()
658486 8.0.6.0, 8.1.5.0 No rows possible from _COMPLEX_VIEW_MERGING & GROUP BY
840242 8.0.5.2, 8.0.6.0 COMPLEX_VIEW_MERGING could core dump

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

相关文章 | Related posts:

  1. Init.ora Parameter "_FIX_CONTROL" [Hidden] Reference Note
  2. Init.ora Parameter "SORT_MULTIBLOCK_READ_COUNT"
  3. ORA-600 quick reference guide
  4. Oracle内部错误:ORA-00600[25012]一例
  5. DIAG: Alter System Dump Undo – Quick Reference
  6. Diagnosing ORA-12004 Refresh Fast Cannot be Used
  7. How does cpu_count parameter affect instance?
  8. Possible Cause of ORA-00354 and ORA-00353 -OR- ARC0: Error 19510 closing archivelog file
  9. Troubleshooting Streams Apply Error ORA-1403, ORA-26787 or ORA-26786
  10. New Parameter DB_ULTRA_SAFE introduce In 11g
Oracle, Oracle初始参数Parameter   , ,  
«  
  »

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

«  
  »