Configuring Linux Hugepages for Oracle Database Is Just Too Difficult! Isn’t It? Part – III. Do You Really Want To Configure The Absolute Minimum Hugepages?

In part I of my recent blog series on Linux hugepages and modern Oracle releases I closed the post by saying that future installments would materialize if I found any pitfalls. I don’t like to blog about bugs, but in cases where there is little material on the matter provided elsewhere I think it adds value. First, however, I’d like to offer links to parts I and II in the series:

The pitfall I’d like to bring to readers’ attention is a situation that can arise in the case where the Oracle Database 11g Release 2 11.2.0.2 parameter use_large_pages is set to “only” thus forcing the instance to either successfully allocate all shared memory from the hugepages pool or fail to boot. As I pointed out in parts I and II this is a great feature. However, after an instance is booted it stands to reason that other processes (e.g., Oracle instances) may in fact use hugepages thus drawing down the amount of free hugepages. In fact, it stands to reason that other uses of hugepages could totally deplete the hugepages pool.

So what happens to a running instance that successfully allocated its shared memory from the hugepages pool and hugepages are later externally drawn down? The answer is nothing. An instance can plod along just fine after instance startup even if hugepages continue to get drawn down to the point of total depletion. But is that the end of the story?

What Goes Up, Must (be able to) Come Down
OK, so for anyone that finds themselves in a situation where an instance is up and happy but HugePages_Free is zero the following is what to expect:

$ sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.2.0 Production on Wed Sep 29 17:32:32 2010

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>
SQL> HOST grep -i huge /proc/meminfo
HugePages_Total:  4663
HugePages_Free:      0
HugePages_Rsvd:     10
Hugepagesize:     2048 kB

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 6422533
SQL>

Pay particular attention to the fact that sqlplus is telling us that it is attached to an idle instance! I assure you, this is erroneous. The instance is indeed up.

Yes, this is bug 10159556 (I filed it for what it is worth). The solution is to have ample hugepages as opposed to precisely enough. Note, in another shell a privileged user can dynamically allocate more hugepages (even a single hugepage) and the instance will be then able to be shutdown cleanly. As an aside, an instance in this situation can be shutdown with abort. I don’t aim to insinuate that this is some sort of zombie instance that will not go away.

14 Responses to “Configuring Linux Hugepages for Oracle Database Is Just Too Difficult! Isn’t It? Part – III. Do You Really Want To Configure The Absolute Minimum Hugepages?”


  1. 1 Flado November 18, 2010 at 11:08 am

    You mean another process can steal memory which I have allocated? Do LOCK_SGA and/or PRE_PAGE_SGA work on Linux and if so, don’t they help to avoid this pitfall?

    I have no experience with Linux hugepages (only with AIX large pages and Oracle 10g).

    Thanks,
    Flado

    • 2 kevinclosson November 18, 2010 at 3:17 pm

      Fldo,

      No, if a process succeeds at shmget with SHM_HUGETLB he owns the pages for that allocation. They will be on the reserved list until touched (faulted)… I’m talking about drawing down what free hugepages remain after the instance boots. The gist of the matter is that if you think you need precisely 1,000 hugepages for your instance you better configure 1,001.

      • 3 Flado November 18, 2010 at 3:48 pm

        Ah, got it. Thanks.
        Does this still happen when trying to shutdown through an already-connected local session or a new/existing TNS session?

        Cheers!
        Flado

        • 4 kevinclosson November 18, 2010 at 6:35 pm

          Hi Flado,

          Good question. I’d have to test. I expect that if the booting foreground stays around (connected) long enough to be the one shutting down there will be no issue… I’ll see if I can test that (if it is less than 5 minutes testing I can probably do it).

  2. 5 Nick November 18, 2010 at 12:46 pm

    Hi Kevin, I wonder if there is any way to understand for each particular shared segment if huge pages were allocated to it or not. For example: two 10g databases running on a box – one SGA is 16GB, another one is ~1GB. 9000 huge pages configured. After bringing databases up I can see:

    grep -i huge /proc/meminfo
    HugePages_Total: 9000
    HugePages_Free: 7479
    HugePages_Rsvd: 7153
    Hugepagesize: 2048 kB

    ipcs -m
    —— Shared Memory Segments ——–
    key shmid owner perms bytes nattch status
    0xc6a860ec 0 oracle 600 1008730112 26
    0x76953ab0 65537 oracle 660 4096 0
    0x00000000 262146 oracle 600 17179869184 29
    0x83cb2f70 294915 oracle 600 2097152 29

    How could I get to know for sure if the small segment using huge pages?

  3. 7 Christo Kutrovsky November 18, 2010 at 4:37 pm

    At some point the permissions were the giveaway if the hugepages are used or not.

    Permissions 600 -> yes, permissions 660 -> no.

    However I have no evidence that this is indeed true 100% of the time. Just observations.

  4. 10 Scott December 8, 2010 at 9:17 pm

    Kevin,
    Ran across an article about transparent huge pages in recent linux kernels. One feature seems to add new process that can convert regular pages into huge pages and be able to swap out huge pages. Don’t know if it work with shared memory segments or not.

    http://www.phoronix.com/scan.php?page=article&item=linux_transparent_hugepages&num=1

  5. 11 Martin Berger (@martinberx) February 7, 2012 at 12:32 am

    Scott,
    I could only find references saying transparent huge pages are working only for anonymous memory mappings right now. So we have to wait for a shared-memory implementation.

  6. 12 Rajeev December 7, 2012 at 8:28 am

    do we need to include pga memory when calculating hugepages when using 11.2.0.3


  1. 1 HugePages Overhead « OraStory Trackback on May 30, 2012 at 12:08 pm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,058 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

Follow

Get every new post delivered to your Inbox.

Join 2,058 other followers

%d bloggers like this: