Memory settings for Oracle
Hello,
I have 256 G of physical memory and two Oracle 19.20 instances with following setup on Prod:
sga_target=0;
sga_max_size=0
pga_aggregate_target=0
memory_target=168G
memory_max_target=184G
After few days in production I see following parameters there:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 184G
sga_max_size big integer 102912M
I assume that pga_aggregate_limit was taken from memory_max_target as I did not set it up.
sga_max_size shows 100 GB so I assume it is set according to current dynamic value. (I set it to 0 during configuration).