日常工作中 Oracle12c参数的处理:

1. Oracle12c 修改过的参数

alter system set result_cache_mode=manual; 
alter system set result_cache_max_size=0; 
alter system set "_optimizer_ads_use_result_cache"=false; 
alter system set "_column_tracking_level" =0 scope=both;
alter system set "_optimizer_enable_extended_stats" = false;
alter system set  "_optimizer_dsdir_usage_control" =0 ;
alter system set OPTIMIZER_ADAPTIVE_FEATURES=false;
alter system set "_fix_control"='17376322:OFF';

2. 修改 oracle version的参数

Alter system set "_cursor_obsolete_threshold"=1024 scope=spfile;

3. Oracle12c 内存参数的修改

modify initora12c.ora
sga and pga
startup pfile= ..../initora12c.ora
create spfile from pfile

shutdown and startup

modify parameter
alter system set db_cache_size=xxxx scope=spfile
alter system set shared_pool_size = xxxx scope=spfile
alter system set inmemory_size=xxxx scope=spfile
alter system set inmemory_max_populate_servers=xxxx scope=spfile

shutdown and startup

alter tablespace xxxxx default inmemory