This discussion is archived
1 Reply Latest reply: Mar 23, 2013 10:35 PM by 606331 RSS

Huge Pages allocation failed (free: 32649 required: 12801)

user113599 Newbie
Currently Being Moderated
we are seeing the below message when the db comes up. I know memlock is not sized properly it should be smaller than ram. I will fix that. But huge page is sized at 64 gb and sum of all sga's on this server is arnd 60gb then why we are seeing this message.

****************** Huge Pages Information *****************
Huge Pages memory pool detected (total: 32768 free: 32444)
Memlock limit too small: 12884901888 to accommodate segment size: 26845642752
Huge Pages allocation failed (free: 32649 required: 12801)
Allocation will continue with default/smaller page size
**********************************************************


Huge page details

MemTotal: 131967344 kB
MemFree: 16764824 kB
Buffers: 1164696 kB
Cached: 35331328 kB
SwapCached: 0 kB
HugePages_Total: 32768
HugePages_Free: 28881
HugePages_Rsvd: 146
Hugepagesize: 2048 kB

Memlock

oracle soft memlock 31457280
oracle hard memlock 31457280
oracle hard nproc 131072
oracle soft nproc 131072
oracle hard nofile 131072
oracle soft nofile 131072
  • 1. Re: Huge Pages allocation failed (free: 32649 required: 12801)
    606331 Explorer
    Currently Being Moderated
    please post os and oracle version?

    above issue it seems to you might have enabled AMM.. i hope .....thats why your facing above huge page issue....note kernel huge pages is not compatible with AMM.
    you need to change from AMM to ASMM.
    like disable or set to 0 MEMORY_TARGET or MEMORY_MAX_TARGET these are AMM

    enable SGA_MAX_TARGET or SGA_TARGET to your value.....ASMM


    please post below details...for further investigation....
    sql> show parameter mem

    sql>show parameter ga

    source is oracle.com

    Edited by: dbc001 on Mar 24, 2013 10:34 AM

    Edited by: dbc001 on Mar 24, 2013 10:57 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points