【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
提问和评论都可以，用心的回复会被更多人看到
评论
发布评论
相关文章
举报文章 请选择举报类型
内容侵权
涉嫌营销
内容抄袭
违法信息
其他
补充说明 0/200 上传截图 格式支持JPEG/PNG/JPG，图片不超过1.9M 如有误判或任何疑问，可联系 「小助手微信：cto51cto」申诉及反馈。
我知道了
             |
