Use Intel Optane DC Persistent Memory for scaling up heavy database analytic workloads inside an Oracle database. Further areas of exploration can include scaling up the use cases beyond 500 GB DRAM, especially when using Oracle in-memory database or analytics-heavy workloads. Increasing memory density can enable the entire Oracle workload to be placed in memory, increasing performance significantly. The performance improvement was demonstrated in Oracle Open World 2019. For more information, go to:
The configurations shown in the following tables are suggested configurations with Intel Optane DC persistent memory. The Optane DC persistent memory is configured as memory mode and no Oracle software change is required.
Table 12. 1-CPU configuration components and details
Chassis |
1-CPU configuration |
Memory |
6 DDR4 Dual Rank 16 GB @ 2,666 MHz 4 Intel Optane PMem 128 GB @ 2,666 MHz |
Processors |
1 x Intel Xeon Gold 6230 CPU @ 2.10 GHz, 16c |
Table 13. 2-CPU configuration components and details
Chassis |
2-CPU configuration |
Memory |
12 DDR4 Dual Rank 16 GB @ 2,666 MHz 4 Intel Optane PMem 128 GB @ 2,666 MHz |
Processors |
2 x Intel Xeon Platinum 8268 CPU @ 2.70 GHz, 24c |
