Implementing huge pages - memory management advice
Oracle SE-2, 12.1.0.2
with Grid Infrastucture for stand-alone ASM, no clustering, no RAC.
Oracle Linux 6
Am finally getting around to taking a serious look at implementing hugepages, before upgrading to 18c. The implementation looks straight forward, but of course we have to turn off AMM, which means I've got to revisit all of my memory parameters. Beyond that, I already have 'use_large_pages=true', so it is my understanding that as soon as the os is configured no further adjustment to the db will be required.
I know there's no point in getting too wadded up trying to find the "perfect" combination of settings. Just thinking that someone could look over my current settings and point out any glaring issues.