脚本宝典收集整理的这篇文章主要介绍了那些在11gR2中可能惹祸的新特性,一张列表帮助你摆脱升级11gR2带来的烦恼,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
REM ===============================FOR STABLE OPTIMIZER=================================== alter System set "_enable_automatic_SQLtune"=false scoPE=both; Automatic SQL Tuning Advisory enabled parameter #以下优化器参数均可以在session/system级别设置,一般优化器参数均可以在线修改 alter session set "_serial_direct_read"=false; alter session set "_nlj_batching_enabled" = 0; alter session set "_optimizer_undo_cost_change" = '10.2.0.4'; -- 11.2.0.1 alter session set "_optimizer_null_aware_antijoin" = false; -- true alter session set "_optimizer_extend_jppd_view_types" = false; -- true alter session set "_replace_virtual_columns" = false; -- true alter session set "_First_k_rows_dynamic_PRoration" = false; -- true alter session set "_bloom_pruning_enabled" = false; -- true alter session set "_optimizer_multi_level_push_pred" = false; -- true alter session set "_optimizer_group_by_placement" = false; -- true alter session set "_optimizer_extended_cursor_sharing_rel" = none; -- simple alter session set "_optimizer_adaptive_cursor_sharing" = false; -- true alter session set "_optimizer_improve_selectivITy" = false ; -- true alter session set "_optimizer_enable_density_improvements" = false; -- true alter session set "_optimizer_native_full_outer_join" = off; -- force alter session set "_optimizer_enable_extended_stats" = false; -- true alter session set "_nlj_batching_enabled" = 0; -- 1 alter session set "_optimizer_extended_stats_usage_control" = 255; -- 224 alter session set "_bloom_folding_enabled" = false; -- true alter session set "_optimizer_coalesce_subqueries" = false; -- true alter session set "_optimizer_fast_pred_transitivity" = false; -- true alter session set "_optimizer_fast_access_pred_analysis" = false; -- true alter session set "_optimizer_unnest_disjunctive_subq" = false; -- true alter session set "_optimizer_unnest_corr_set_subq" = false; -- true alter session set "_optimizer_distinct_agg_transform" = false; -- true alter session set "_aggregation_optimization_settings" = 32; -- 0 alter session set "_optimizer_connect_by_elim_dups" = false; -- true alter session set "_optimizer_eliminate_filtering_join" = false; -- true alter session set "_connect_by_use_union_all" = old_plan_mode; --true alter session set "_optimizer_join_factorization" = false; -- true alter session set "_optimizer_use_cbqt_star_transformation" = false; -- true alter session set "_optimizer_table_expansion" = false ; -- true alter session set "_and_pruning_enabled" = false ; -- true alter session set "_optimizer_distinct_placement" = false ; -- true alter session set "_optimizer_use_feedback" = false ; -- true alter session set "_optimizer_try_st_before_jppd" = false ; -- true REM ===============================MEMORY=================================== alter system set "_memory_imm_mode_without_autosga"=false scope=both; alter system set "_enable_shared_pool_durations"=false scope=spfile; REM ===============================SEGMENT================================== alter system set deferred_segment_creation=false; .................
REM ===============================FOR STABLE OPTIMIZER=================================== alter system set "_enable_automatic_sqltune"=false scope=both; Automatic SQL Tuning Advisory enabled parameter #以下优化器参数均可以在session/system级别设置,一般优化器参数均可以在线修改 alter session set "_serial_direct_read"=false; alter session set "_nlj_batching_enabled" = 0; alter session set "_optimizer_undo_cost_change" = '10.2.0.4'; -- 11.2.0.1 alter session set "_optimizer_null_aware_antijoin" = false; -- true alter session set "_optimizer_extend_jppd_view_types" = false; -- true alter session set "_replace_virtual_columns" = false; -- true alter session set "_first_k_rows_dynamic_proration" = false; -- true alter session set "_bloom_pruning_enabled" = false; -- true alter session set "_optimizer_multi_level_push_pred" = false; -- true alter session set "_optimizer_group_by_placement" = false; -- true alter session set "_optimizer_extended_cursor_sharing_rel" = none; -- simple alter session set "_optimizer_adaptive_cursor_sharing" = false; -- true alter session set "_optimizer_improve_selectivity" = false ; -- true alter session set "_optimizer_enable_density_improvements" = false; -- true alter session set "_optimizer_native_full_outer_join" = off; -- force alter session set "_optimizer_enable_extended_stats" = false; -- true alter session set "_nlj_batching_enabled" = 0; -- 1 alter session set "_optimizer_extended_stats_usage_control" = 255; -- 224 alter session set "_bloom_folding_enabled" = false; -- true alter session set "_optimizer_coalesce_subqueries" = false; -- true alter session set "_optimizer_fast_pred_transitivity" = false; -- true alter session set "_optimizer_fast_access_pred_analysis" = false; -- true alter session set "_optimizer_unnest_disjunctive_subq" = false; -- true alter session set "_optimizer_unnest_corr_set_subq" = false; -- true alter session set "_optimizer_distinct_agg_transform" = false; -- true alter session set "_aggregation_optimization_settings" = 32; -- 0 alter session set "_optimizer_connect_by_elim_dups" = false; -- true alter session set "_optimizer_eliminate_filtering_join" = false; -- true alter session set "_connect_by_use_union_all" = old_plan_mode; --true alter session set "_optimizer_join_factorization" = false; -- true alter session set "_optimizer_use_cbqt_star_transformation" = false; -- true alter session set "_optimizer_table_expansion" = false ; -- true alter session set "_and_pruning_enabled" = false ; -- true alter session set "_optimizer_distinct_placement" = false ; -- true alter session set "_optimizer_use_feedback" = false ; -- true alter session set "_optimizer_try_st_before_jppd" = false ; -- true REM ===============================MEMORY=================================== alter system set "_memory_imm_mode_without_autosga"=false scope=both; alter system set "_enable_shared_pool_durations"=false scope=spfile; REM ===============================SEGMENT================================== alter system set deferred_segment_creation=false; .................
以上是脚本宝典为你收集整理的那些在11gR2中可能惹祸的新特性,一张列表帮助你摆脱升级11gR2带来的烦恼全部内容,希望文章能够帮你解决那些在11gR2中可能惹祸的新特性,一张列表帮助你摆脱升级11gR2带来的烦恼所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。