oracledba.help
SpecialTopics

SGA-PGA Models

 -- 128g\64g
 alter system set sga_max_size=128g         scope=spfile;
 alter system set sga_target=128g           scope=spfile;
 alter system set pga_aggregate_target=64g  scope=spfile;

 -- 64g\32g
 alter system set sga_max_size=64g          scope=spfile;
 alter system set sga_target=64g            scope=spfile;
 alter system set pga_aggregate_target=32g  scope=spfile;

 -- 2394m\798m
 alter system set sga_max_size=2394m        scope=spfile;
 alter system set sga_target=2394m          scope=spfile;
 alter system set pga_aggregate_target=798m scope=spfile;

 -- 1536m\256m
 alter system set sga_max_size=1536m        scope=spfile;
 alter system set sga_target=1536m          scope=spfile;
 alter system set pga_aggregate_target=256m scope=spfile;

 -- 1200m\256m
 alter system set sga_max_size=1200m        scope=spfile;
 alter system set sga_target=1200m          scope=spfile;
 alter system set pga_aggregate_target=400m scope=spfile;

 -- 1024m\256m
 alter system set sga_max_size=1024m        scope=spfile;
 alter system set sga_target=1024m          scope=spfile;
 alter system set pga_aggregate_target=256m scope=spfile;

 -- 512m\64m
 alter system set sga_max_size=512m        scope=spfile;
 alter system set sga_target=512m          scope=spfile;
 alter system set pga_aggregate_target=64m scope=spfile;