1. 由AMM调整为ASMM管理模式
sqlplus -S "/ as sysdba" <<-EOF
-- 备份参数
create pfile='/tmp/pfile_bak.ora' from spfile;
-- 配置sga和pga
alter system set sga_target=160G scope=spfile sid='*';
alter system set sga_max_size=240G scope=spfile sid='*';
alter system set pga_aggregate_target=24G scope=spfile sid='*';
-- alter system set shared_pool_size=40G scope=spfile sid='*';
-- alter system set db_cache_size=100G scope=spfile sid='*';
alter system set memory_target=0 scope=spfile sid='*';
alter system set memory_max_target=0 scope=spfile sid='*';
alter system reset memory_max_target scope=spfile sid='*';
EOF
