Month: April 2009

To see the current values use ‘show parameter sga_target’. To alter:

alter system set sga_max_size = 300M scope=spfile;
alter system set sga_target = 300M scope=spfile;

Restart database to effectuate change.