Setting the System Global Area (SGA) in Oracle
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:
Read other posts