sga_max_size
in order to make sure this amount of memory can be provided to processes that need memory. sga_max_size
is larger than the sum of configured size for SGA components, the remaining memory is found/seen in the variable SGA. sga_max_size
should not be set if memory_target
is set. sum(value) from v$sga
is not rounded up to a granule size? (See MOS note 266702.1) select to_number(value) from v$parameter where name = 'sga_max_size' union all select sum(value) from v$sga;