【12c新特性】CBO Optimizer優化器新特性清單【12c新特性】CBO Optimizer優化器新特性清單

【12c新特性】CBO Optimizer新隐藏參數，以下Optimizer優化器新特性清單，通過對比 12c R1 和 11gR2的10053 trace中有影響的優化器參數獲得：  

CLI_internal_cursor

PMO_altidx_rebuild

_adaptive_window_consolidator_enabled

_arch_comp_dbg_scan

_array_cdb_view_enabled

_bloom_filter_size

_bloom_predicate_offload

_bloom_rm_filter

_bloom_sm_enabled

_cell_materialize_all_expressions

_cell_materialize_virtual_columns

_cell_offload_complex_processing

_cell_offload_expressions

_cell_offload_sys_context

_common_data_view_enabled

_dbg_scan

_fast_index_maintenance

_hashops_prefetch_size

_long_varchar_allow_IOT

_multi_commit_global_index_maint

_oltp_comp_dbg_scan

_optimizer_adaptive_plans

_optimizer_ads_max_table_count

_optimizer_ads_time_limit

_optimizer_ads_use_result_cache

_optimizer_ansi_join_lateral_enhance

_optimizer_ansi_rearchitecture

_optimizer_batch_table_access_by_rowid

_optimizer_cluster_by_rowid

_optimizer_cluster_by_rowid_control

_optimizer_cube_join_enabled

_optimizer_dsdir_usage_control

_optimizer_gather_feedback

_optimizer_gather_stats_on_load

_optimizer_generate_transitive_pred

_optimizer_hybrid_fpwj_enabled

_optimizer_multi_table_outerjoin

_optimizer_null_accepting_semijoin

_optimizer_partial_join_eval

_optimizer_performance_feedback

_optimizer_proc_rate_level

_optimizer_proc_rate_source

_optimizer_strans_adaptive_pruning

_optimizer_unnest_scalar_sq

_optimizer_use_gtt_session_stats

_optimizer_use_histograms

本文轉自maclean_007 51CTO部落格，原文連結:http://blog.51cto.com/maclean/p2