Change the SGA size 1 2 alter system set sga_max_size=20480M scope=spfile; alter system set sga_target=20480M scope=spfile; Since this change only applies to the spfile, you have to bounce the database when done.