patternMinor
What is the recommended memory_target and memory_max_target for ORACLE 12 DB running on a dedicated server with 32GB RAM?
Viewed 0 times
memory_targetthewhatserverrecommendedmemory_max_targetwith32gbdedicatedrunning
Problem
What is the recommended
The server is dedicated to the Oracle 12 database.
Is there any recommendations in such case?
memory_target and memory_max_target for ORACLE DB running on a dedicated linux server with 32GB RAM?The server is dedicated to the Oracle 12 database.
Is there any recommendations in such case?
Solution
Forget
When I have no information about earlier memory usage, I just go with a 1:4 ratio for PGA:SGA target.
Which implicitly sets:
Then later you can tune if needed, after observing the workload and memory usage.
memory_target and memory_max_target. AMM has always been a feature that worked on paper, but failed in practice. Oracle finally admitted it semi-officially as of the release of 12.2:When I have no information about earlier memory usage, I just go with a 1:4 ratio for PGA:SGA target.
sga_target=20G
pga_aggregate_target=5GWhich implicitly sets:
sga_max_size=20G
pga_aggregate_limit=10GThen later you can tune if needed, after observing the workload and memory usage.
Code Snippets
sga_target=20G
pga_aggregate_target=5Gsga_max_size=20G
pga_aggregate_limit=10GContext
StackExchange Database Administrators Q#197650, answer score: 4
Revisions (0)
No revisions yet.