配置oracle的asmm管理
-- 关闭AMM
alter system set memory_target=0 scope=spfile;
alter system set memory_max_target=0 scope=spfile;
-- 配置ASMM(SGA自动管理)
alter system set sga_target=2048M scope=spfile;
alter system set sga_max_size=2048M scope=spfile;
-- 配置自动PGA管理
alter system set pga_aggregate_target=1024M scope=spfile;
alter system set pga_aggregate_limit=2048M scope=spfile;
浙公网安备 33010602011771号