Available HugePages are not being allocated/used by 19c Database...
Hello all,
inspite of the following settings (RHEL-8.9 in Azure);
- /etc/security/limits.d/90-oracle.conf
- soft memlock 7680000
- /etc/sysctl.d/90-oracle.conf
- kernel.shmmax = 13221366989
- vm.nr_hugepages = 3074
the resulting HugePages are not being allocated to/used by the instance.
$ grep -E ugePag /proc/meminfo
AnonHugePages: 0 kB
ShmemHugePages: 0 kB
FileHugePages: 0 kB
HugePages_Total: 3074
HugePages_Free: 3074
HugePages_Rsvd: 0
HugePages_Surp: 0
$ grep -E -A10 EXPECTED diag/rdbms/…/trace/alert_….log
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
4K Configured 15 1572879 NONE
2048K 3074 3073 0 NONE
RECOMMENDATION:
2024-05-08T14:54:41.302416+02:00
- Increase per process memlock (soft) limit to at least 6146MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory