欧陆资讯 NEWS CENTER
联系我们 CONTACT US
- 手机:
- 18888889999
- 电话:
- 0898-66889888
- 邮箱:
- admin@youweb.com
- 地址:
- 海南省海口市玉沙路58号
【12c新特性】CBO Optimizer优化器新特性列表
2024-08-26 05:37:56 点击量:
【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 |