Re: Oracle ASM and Hugepages

From: Mark J. Bobak <mark_at_bobak.net>
Date: Sun, 09 Oct 2016 18:35:17 +0000
Message-ID: <CAFQ5AC+HJGR3LyU1swZ8FAVnE0soTb-siaEB01hJyc9jcp5iiQ_at_mail.gmail.com>



Good point.

On Sun, Oct 9, 2016, 14:32 Maris Elsins <elmaris_at_gmail.com> wrote:

> Hi,
>
> I think the main reason for considering hugepages for ASM is not the
> reduction of the footprint of the page table, but the fact that SGA
> wouldn't be swapped out when hugepages are used, which is good enough
> reason to use them even for ASM
>
> ---
> Maris Elsins
> _at_MarisElsins <https://twitter.com/MarisElsins>
>
>
>
> On Sun, Oct 9, 2016 at 9:10 PM, Franck Pachot <franck_at_pachot.net> wrote:
>
> Hi,
> In Exadata Database Machine 11.2.0.4 Grid Infrastructure and Database
> Upgrade for 11.2.0.2 BP11 and earlier (Doc ID 1555036.1)
> <https://support.oracle.com/epmos/faces/DocContentDisplay?id=1555036.1#aref_section226>
>
> You can read: Allocate additional hugepages so that both ASM and database
> instance can use hugepages
> Regards,
> Franck.
>
>
> On Sun, Oct 9, 2016 at 7:40 PM Sanjay Mishra <dmarc-noreply_at_freelists.org>
> wrote:
>
> Thanks Mark for the update. I can see that Oracle provided script to
> suggest for hugepage parameter recommendation is also not taking ASM memory
> in the picture. So looking for comment from others based on their
> experience appreciate your feedback
>
> Tx
> Sanjay
>
>
> On Sunday, October 9, 2016 1:29 PM, Mark J. Bobak <mark_at_bobak.net> wrote:
>
>
> Hi Sanjay
> My opinion, you can use huge pages for ASM if you wish, but don't bother.
> It's not generally enough memory to make much of a difference.
> Huge pages for RSBMS, on the other hand, is an absolute must. I blogged
> on this topic a few years ago.
>
> https://www.google.com/amp/s/markjbobak.wordpress.com/2014/01/21/if-youre-not-using-hugepages-youre-doing-it-wrong/amp/
> -Mark
>
> On Sun, Oct 9, 2016, 13:21 Sanjay Mishra <dmarc-noreply_at_freelists.org>
> wrote:
>
> Hi
>
> Can anyone provide insight if you are using Hugepages for ASM as well as
> RDBMS on your 11gR2 (11.2.0.3) onwards or if you are using AMM for ASM and
> hugespages for RDBMS. ?
>
> Saw various Oracle Article saying to use AMM for ASM and Hugepages with
> ASMM with RDBMS. Please update your opinion and recommendation
>
> Regards
> Sanjay
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 09 2016 - 20:35:17 CEST

Original text of this message