12CR2 vs 11gR2 新增optimizer 参数列表

_optimizer_adaptive_plan_control	0
_optimizer_adaptive_plans_continuous	FALSE
_optimizer_adaptive_plans_iterative	FALSE
_optimizer_adaptive_random_seed	0
_optimizer_ads_for_pq	FALSE
_optimizer_ads_result_cache_life	3600
_optimizer_ads_spd_cache_owner_limit	64
_optimizer_ads_use_partial_results	TRUE
_optimizer_ads_use_spd_cache	TRUE
_optimizer_aggr_groupby_elim	TRUE
_optimizer_ansi_join_lateral_enhance	TRUE
_optimizer_ansi_rearchitecture	TRUE
_optimizer_band_join_aware	TRUE
_optimizer_batch_table_access_by_rowid	TRUE
_optimizer_bushy_cost_factor	100
_optimizer_bushy_fact_dim_ratio	20
_optimizer_bushy_fact_min_size	100000
_optimizer_bushy_join	off
_optimizer_cbqt_or_expansion	ON
_optimizer_cluster_by_rowid	TRUE
_optimizer_cluster_by_rowid_batch_size	100
_optimizer_cluster_by_rowid_batched	TRUE
_optimizer_cluster_by_rowid_control	129
_optimizer_control_shard_qry_processing	65534
_optimizer_cube_join_enabled	TRUE
_optimizer_db_blocks_buffers	0
_optimizer_dsdir_usage_control	0
_optimizer_eliminate_subquery	TRUE
_optimizer_enable_plsql_stats	TRUE
_optimizer_enhanced_join_elimination	TRUE
_optimizer_gather_feedback	TRUE
_optimizer_gather_stats_on_load	TRUE
_optimizer_generate_ptf_implied_preds	TRUE
_optimizer_generate_transitive_pred	TRUE
_optimizer_hll_entry	4096
_optimizer_hybrid_fpwj_enabled	TRUE
_optimizer_inmemory_access_path	TRUE
_optimizer_inmemory_autodop	TRUE
_optimizer_inmemory_bloom_filter	TRUE
_optimizer_inmemory_capture_stored_stats	TRUE
_optimizer_inmemory_cluster_aware_dop	TRUE
_optimizer_inmemory_gen_pushable_preds	TRUE
_optimizer_inmemory_minmax_pruning	TRUE
_optimizer_inmemory_pruning_ratio_rows	100
_optimizer_inmemory_quotient	0
_optimizer_inmemory_table_expansion	TRUE
_optimizer_inmemory_use_stored_stats	AUTO
_optimizer_interleave_or_expansion	TRUE
_optimizer_key_vector_aggr_factor	75
_optimizer_key_vector_pruning_enabled	TRUE
_optimizer_multi_table_outerjoin	TRUE
_optimizer_multicol_join_elimination	TRUE
_optimizer_nlj_hj_adaptive_join	TRUE
_optimizer_null_accepting_semijoin	TRUE
_optimizer_partial_join_eval	TRUE
_optimizer_performance_feedback	OFF
_optimizer_proc_rate_level	BASIC
_optimizer_proc_rate_source	DEFAULT
_optimizer_reduce_groupby_key	TRUE
_optimizer_strans_adaptive_pruning	TRUE
_optimizer_synopsis_min_size	2
_optimizer_undo_cost_change	12.2.0.1
_optimizer_union_all_gsets	TRUE
_optimizer_unnest_scalar_sq	TRUE
_optimizer_use_feedback_for_join	FALSE
_optimizer_use_gtt_session_stats	TRUE
_optimizer_use_histograms	TRUE
_optimizer_use_table_scanrate	HADOOP_ONLY
_optimizer_use_xt_rowid	TRUE
_optimizer_vector_base_dim_fact_factor	200
_optimizer_vector_cost_adj	100
_optimizer_vector_fact_dim_ratio	10
_optimizer_vector_min_fact_rows	10000000
_optimizer_vector_transformation	TRUE
optimizer_adaptive_plans	TRUE
optimizer_adaptive_reporting_only	FALSE
optimizer_adaptive_statistics	FALSE
optimizer_features_enable	12.2.0.1
optimizer_inmemory_aware	TRUE

此条目发表在 Oracle 分类目录。将固定链接加入收藏夹。

12CR2 vs 11gR2 新增optimizer 参数列表

3D Cloud

QQ咨询

最近发表

Contributors