Re: Oracle ASM and Hugepages

From: Maris Elsins <elmaris_at_gmail.com>
Date: Sun, 9 Oct 2016 21:32:52 +0300
Message-ID: <CABQhObsPbsSGcnsTV7MFg+UvnPyH2a396KqVTqBnLw=Y8-GKnQ_at_mail.gmail.com>



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:32:52 CEST

Original text of this message