DB parameter changes Proposal
Hello All,
I have a requirement with the below request , to alter the parameters (11.2.0.3.0 - 64bit Production on / Oracle Linux Server release 7.3) ,
Current settings :
=-=-=-=-=-=-=-=
= > show parameter sga_max_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 120G
=> show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 112G
=> show parameter memory_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 0
SQL> show parameter memory_max_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 0
To be set to:
=-=-=-=-=-=