Re: Anonymous huge pages for Linux

Todd,

Your terse answer reminded me of this classic bit from Mel Brooks in the 1976 movie "Silent Movie"...

https://www.youtube.com/watch?v=IhhS13sk7eg

It takes almost two minutes to get to the punchlines, but it is so worth it.  Any time you can watch Dom DeLuise, Marty Feldman, Sid Caesar, and Mel Brooks in a scene with Marcel Marceau... tout simplement magnifique!

Thanks!

-Tim

On 1/9/2023 3:25 PM, Todd Bellaver wrote:
> Jon,
>
> My apologies for the sharp NO.  It was an echo from when a bunch of us
> talked about this over a night of DBA debauchery. Mark, thanks for the
> better answer.
>
> My 2-cents.  Consider configuring your Oracle DB server build policy
> to set huge pages to 40% of physical memory. This 40% is for the
> _combined_ SGAs of all the databases on the database server.  The
> other 60% is for the _combined _PGA Aggregate Limits (*not targets*)
> of all the databases on that server and OS.  40% is just a suggestion,
> 35% may be better.  Do the math for what works best for your environment.
>
> I hope this is also a better answer.
>
> Best of luck on your Oracle adventures.
>
> Todd
>
>
>
> On Mon, Jan 9, 2023 at 5:26 PM Mark J. Bobak <mark_at_bobak.net> wrote:
>
> To the best of my knowledge, anonymous husepages are still a
> non-starter when it comes to Oracle.
>
> On Mon, Jan 9, 2023 at 3:44 PM 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