配置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;

posted @ 2026-04-09 11:39  wuyingchun1987  阅读(3)  评论(0)    收藏  举报