Re: Anonymous huge pages for Linux

Jon, if you are on 19c have you looked at use_large_pages=auto_only?

I wrote a blog post (Exadata related but the parameter is generic) about it a while ago. Kind-of does what you want but like all automation, it’s not perfect. Not capping the number huge pages has downsides.

<https://chandlerdba.com/2022/04/12/huge-pages-on-exadata/>
[huge_page.jpg]
Huge Pages on Exadata<https://chandlerdba.com/2022/04/12/huge-pages-on-exadata/> chandlerdba.com<https://chandlerdba.com/2022/04/12/huge-pages-on-exadata/>

Neil Chandler
sent from my phone

On 9 Jan 2023, at 20:44, Jon Crisler <joncrisler_at_gmail.com> wrote:


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






(image/jpeg attachment: huge_page.jpg)