关闭12C部分参数

转自https://dbanote.github.io/2017/04/18/oracle/%E9%82%A3%E4%BA%9B12c%E4%B8%AD%E6%83%B9%E7%A5%B8%E7%9A%84%E7%89%B9%E6%80%A7%E5%85%B3%E9%97%AD%E5%88%97%E8%A1%A8/

alter system set "_optimizer_aggr_groupby_elim"=false;
alter system set "_drop_stat_segment"=1;
alter system set "_common_data_view_enabled"=false; 
alter system set "_optimizer_dsdir_usage_control"=0;    // disable SQL Plan Directive
alter system set optimizer_adaptive_features=false;
alter system set "_optimizer_adaptive_plans"=false;
alter system set "_optimizer_gather_feedback"=false;
alter system set "_optimizer_enable_extended_stats"=false;
alter system set "_optimizer_ads_use_result_cache"=false;
alter system set "_use_single_log_writer"=true scope=spfile; //Multiple log writers feature in Oracle Database 12c can cause instance recovery fails and unexpected