1 Reply Latest reply: Mar 24, 2013 12:35 AM by 606331 RSS

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

    user11991981
      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
          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