oracledba.help works great on your mobile device too!

oracledba.help

SGA-PGA Models

<- SpecialTopics

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

 -- 1200m\400m
 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;