Oracle-内存管理机制

1. 由AMM调整为ASMM管理模式

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15

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