Good evening everyone, our developer has changed the parameters of MEMORY_TARGET and MEMORY_MAX_TARGET in order to increase the execution speed of our oracle database by passing the values to 8G, but after verification we have:
NAME TYPE VALUE
------------------------------------ -------------- ---------------------------
sga_target big integer 7808M
SQL> show parameter sga_max_size;
NAME TYPE VALUE
------------------------------------ -------------- ---------------------------
sga_max_size big integer 7808M
SQL> show parameter pga_aggregate_target;
NAME TYPE VALUE
------------------------------------ -------------- ---------------------------
pga_aggregate_target big integer 2600M
SQL> show parameter pga_aggregate_limit;
NAME TYPE VALUE
------------------------------------ -------------- ---------------------------
pga_aggregate_limit big integer 5200M
SQL> 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
SQL>
My question is whether the values obtained are normal because after restarting the server the BD no longer runs but as it is a VM under hyper-V I restored from a checkpoint and everything has started again but I'm afraid to restart the server to avoid crashing again.