Database Administration (MOSC)

MOSC Banner

How to verify if Large Pages are used by the database?

edited Apr 15, 2016 5:04AM in Database Administration (MOSC) 7 commentsAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center