Oracle memory management
Memory management is the most critical and complex part of tuning Oracle databases for performance. Our testing environment confirmed that using AMM provided better performance if the correct initial settings for MEMORY_TARGET are specified.
Number of nodes | MEMORY_TARGET |
|---|---|
20,000 | 16 GB |
50,000 | 24 GB |
100,000 | 48 GB |
150,000 | 72 GB |
200,000 | 96 GB |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*