Re: undersized SGA

Posted by ErmanArslansOracleBlog on Nov 06, 2019; 1:34pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/undersized-SGA-tp7823p7827.html

Check your Memory usage by using free command.
you can use sar utility for an historical memory consumption report as well.

The report says : Increase the size of the SGA by setting the parameter "sga_target" to 12600 M
So start with 12600M first..
The reports also complains about the PGA size. As you know, pga_aggregate_target is not a limit, but lots of parameters are derived from that.. you may increase this one as well..

But first you need to determine your memory consumption..
also note that, after increasing the values, get the same report once again and see if those "undersized...." recommendations are cleared.

One last thing, in RAC we set the same sga and pga values for each node. So if you want to increase SGA or PGA, you will increase it in both nodes. That means, you need to make your memory consumption analysis on both nodes..(because PGA consumption may differ according to the nodes)