I am using OEL 6.3.4 (?) running Oracle 11g r2 11.2.0.4. Page size is 2M by default. I have set to use large huge pages and I can verify that they are being used by looking at alert logs and in /proc/meminfo and my sga is all in large huge pages.
My question is about transparent huge pages instead. Oracle has a metal ink note which says to disable them:
https://support.oracle.com/epmos/faces/Registration?_adf.ctrl-state=1txlnfyh8_4&_afrLoop=33725260239640
I am not using RAC. My Linux Server not only has Oracle database installed, but also many java programs of my applications. Transparent huge pages were developed so various java programs can take advantage of them without making any changes to application.
Therefore, is it necessary to disable them?
Even when I disabled them following instructions in metal ink article, I see they are still being used by Oracle db writer and arch processes? Googling shows others also find that these Oracle processes use annon huge pages memory; so transparent huge pages are “not getting disabled”
Appreciate your insight.