Skip to content

Setting the System Global Area (SGA) in Oracle

Posted on:August 19, 2010

Need to increase or decrease the SGA? Use the following:

alter system set sga_max_size = 1024M scope=SPFILE;
alter system set sga_target = 1024M;

Changing the sga_max_size also requires an oracle restart.

References: