Oracle-内存管理机制

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