Enable HUGE PAGES in Oracle database.

Calculate huge page number :

Use script provided in Doc - 401749.1 from My Oracle Support  ( the script is listed here : calculate_hugepages.sh )

Increase the parameters values in sysctl.conf and limits.conf to match the calculated values .

Change database init parameter : change use_large_pages = TRUE 

Reboot system and start databases.

In the alert_log you should be able to see the large page usage . check for below string after instance start :

in 11i >  Large Pages used by   

in 12c >  PAGESIZE  

You can read more on Oracle support site documents : 

HugePages on Oracle Linux 64-bit (Doc ID 361468.1 and 361323.1)



















                                                                                                                                 -contributed by Vikram Kotwani