The settings provided in the following table were applied during all use cases and test cases.
Table 5. Operating system settings
Parameter / component |
Value |
Operating system |
Oracle Linux 7.7 with the Unbreakable Enterprise Kernel (UEK) Release 5 Update 2 [4.14.35-1902.0.18.el7uek.x86_64] |
I/O scheduler |
deadline* (default operating system setting) |
- NUMA & Transparent HugePages settings: /etc/default/grub - /etc/sysconfig/network - User Limits settings: /etc/security/limits.d/oracle-database-preinstall-19c.conf - Kernel parameters: /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf |
All values as set by Oracle Linux Oracle Database 19c pre-install RPM [oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm] |
The following table shows the vm.nr_hugepages settings applied to each test case in the /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf file. The values were determined and set using Oracle’s hugepages_settings.sh script that can be found at My Oracle Support note 401749.1.
Table 6. HugePages settings applied to each use case 1 and use case 2 test cases
|
Use Case 1: 1 TB OLAP |
Use Case 1: 3 TB OLAP |
Use Case 2 |
||
Compression |
768 GB DRAM-only |
1.5 TB PMem-MM |
1.5 TB DRAM-only |
3 TB PMem-MM |
All Tests |
Capacity High |
250,887 (Test 1.1.1) |
250,887 (Test 1.1.3) |
614,408 (Test 1.2.1) |
456,975 (Test 1.2.4) |
250,887 |
Capacity Low |
N/A |
N/A |
614,408 (Test 1.2.2) |
456,975 (Test 1.2.5) |
N/A |
Query High |
N/A |
N/A |
614,408 (Test 1.2.3) |
456,975 (Test 1.2.6) |
N/A |
Query Low |
250,887 (Test 1.1.2) |
614,407 (Test 1.1.4) |
N/A |
N/A |
N/A |