Re: Anonymous huge pages for Linux

Hello Jon,
THP are for anonymous (= heap) memory and not for shared memory like SGA - so THPs are not gonna help you anyway for SHM.

If you want to make the SHM (in Oracle‘s case the SGA) use huge pages, you have to configure them (manually) via kernel parameter but as these are fixed sizes you could write a script for that very easily.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Jon Crisler <joncrisler_at_gmail.com> hat am 09.01.2023 21:42 CET geschrieben:
>
>
> Has anybody had success using anonymous huge pages in later versions of Red Hat or OEL ? The accepted practice has been to disable anonymous huge pages and use fixed huge pages, due to performance issues and bugs. However we are working on a project that may require the rapid provision of small test databases, which will make maintaining manual huge pages a headache. If anonymous huge pages work well now, that would be my preferred configuration.

--
http://www.freelists.org/webpage/oracle-l