sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 运维DBA >

【学习笔记】12.1.0.2 mimic optimizer_features_enable使用案例

时间:2016-11-07 09:35   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 12.1.0.2 mimic optimizer_features_enable=’11.2.0.4′,Oracle研究中心学习笔记:分享一篇关于Oracle12C数据库的管理文档,详细介绍如何通过下面的优化器的参数配置,我们可以让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 | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【学习笔记】12.1.0.2 mimic optimizer_features_enable使用案例

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1195.html

Oracle研究中心

关键词:

Oracle优化器的参数配置

12.1.0.2 mimic optimizer_features_enable=’11.2.0.4′

让12.1.0.2的优化器回到11.2.0.4模式