Re: Anonymous huge pages for Linux

I am not familiar with this particular setting - use_large_pages=auto_only- I will look into it.

On Tue, Jan 10, 2023 at 2:26 AM Neil Chandler <neil_chandler_at_hotmail.com> wrote:

> 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.
>
> [image: 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/>
> <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)