How to verify if Large Pages are used by the database?
We configured Huge Pages on our Linux 2.6 host using the following Doc ID ( Doc ID 361323.1 ) and Document 401749.1
ALTER SYSTEM SET use_large_pages='ONLY' SCOPE=SPFILE;
grep Huge /proc/meminfo
AnonHugePages: 0 kb
HugePages_Total: 3230
HugePages_Free: 156
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize 2048 kb
My concern is that the HugePages_Rsvd: is 0 even after we rebooted the Host several times.
Also my understanding is that in the database alert log I should be seeing a section similar to this:
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Parameter use_large_pages = ONLY
Total Shared Global Region in Large Pages = 4018 MB (100%)
Large Pages used by this instance: 2009 (4018 MB)