当前位置: 首页 > ORACLE > 正文

12.1.0.2 mimic optimizer_features_enable=’11.2.0.4′

通过下面的优化器的参数配置,我们可以让12.1.0.2的优化器回到11.2.0.4模式

alter session set "_optimizer_undo_cost_change" = 11.2.0.4;
alter session set "_adaptive_window_consolidator_enabled" = false;
alter session set "_distinct_agg_optimization_gsets" = off;
alter session set "_gby_vector_aggregation_enabled" = false;
alter session set "_optimizer_aggr_groupby_elim" = false;
alter session set "_optimizer_ansi_join_lateral_enhance" = false;
alter session set "_optimizer_ansi_rearchitecture" = false;
alter session set "_optimizer_batch_table_access_by_rowid" = false;
alter session set "_optimizer_cluster_by_rowid" = false;
alter session set "_optimizer_cluster_by_rowid_batched" = false;
alter session set "_optimizer_cube_join_enabled" = false;
alter session set "_optimizer_gather_stats_on_load" = false;
alter session set "_optimizer_hybrid_fpwj_enabled" = false;
alter session set "_optimizer_multi_table_outerjoin" = false;
alter session set "_optimizer_null_accepting_semijoin" = false;
alter session set "_optimizer_partial_join_eval" = false;
alter session set "_optimizer_proc_rate_level" = off;
alter session set "_optimizer_reduce_groupby_key" = false;
alter session set "_optimizer_unnest_scalar_sq" = false;
alter session set "_optimizer_use_gtt_session_stats" = false;
alter session set "_optimizer_vector_transformation" = false;
alter session set "_px_concurrent" = false;
alter session set "_px_cpu_autodop_enabled" = false;
alter session set "_px_external_table_default_stats" = false;
alter session set "_px_filter_parallelized" = false;
alter session set "_px_filter_skew_handling" = false;
alter session set "_px_groupby_pushdown" = choose;
alter session set "_px_join_skew_handling" = false;
alter session set "_px_object_sampling_enabled" = false;
alter session set "_px_parallelize_expression" = false;
alter session set "_px_partial_rollup_pushdown" = off;
alter session set "_px_replication_enabled" = false;
alter session set "_px_single_server_enabled" = false;
alter session set "_px_wif_dfo_declumping" = off;
alter session set "_px_wif_extend_distribution_keys" = false;
alter session set "_optimizer_cluster_by_rowid_control" = 3;
alter session set "_optimizer_inmemory_access_path" = false;
alter session set "_optimizer_inmemory_autodop" = false;
alter session set "_optimizer_inmemory_bloom_filter" = false;
alter session set "_optimizer_inmemory_cluster_aware_dop" = false;
alter session set "_optimizer_inmemory_gen_pushable_preds" = false;
alter session set "_optimizer_inmemory_minmax_pruning" = false;
alter session set "_optimizer_inmemory_table_expansion" = false;

本文固定链接: http://www.htz.pw/2016/05/10/12-1-0-2-mimic-optimizer_features_enable11-2-0-4.html | 认真就输

该日志由 huangtingzhong 于2016年05月10日发表在 ORACLE 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: 12.1.0.2 mimic optimizer_features_enable=’11.2.0.4′ | 认真就输