Re: Anonymous huge pages for Linux

From: Jon Crisler <joncrisler_at_gmail.com>
Date: Tue, 10 Jan 2023 02:30:48 -0500
Message-ID: <CAB44qRRf_oaXJ4AH3OqY3Qcyhj6dHLXJcq+qa+NH_mfZLANWRA_at_mail.gmail.com>



If I recall, I had THP working for 19c just fine, but I had a few reports from coworkers of issues, plus a known gotcha where Oracle Support warned against it. I may try it again just to validate weather I imagined my results :)

On Tue, Jan 10, 2023 at 1:30 AM Stefan Koehler <contact_at_soocs.de> wrote:

> 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
Received on Tue Jan 10 2023 - 08:30:48 CET

Original text of this message