Hello,
Version 10204 , on linux redhat 4.8
I have a machine with 32 GB memory . Only 12 GB is set for the SGA , 6 Gb is set for the PGA .
12 Gb are free.
one hour ADDM report advice to increase the size of the SGA to 24 GB :
RECOMMENDATION 1: DB Configuration, 12% benefit (192423 seconds)
ACTION: Increase the size of the SGA by setting the parameter "sga_target" to 24576 M.
ADDITIONAL INFORMATION:
The value of parameter "sga_target" was "12288 M" during the analysis period.
Is there a best practice for how much i can increase the SGA without getting ORA-4031 ? can i safely set it to 20GB ?
$ free -m
total used free shared buffers cached
Mem: 32170 19522 12648 0 165 13868
-/+ buffers/cache: 5488 26682
Swap: 20462 552 19910
show parameter ga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 12G
sga_target big integer 12G
pga_aggregate_target big integer 6G