Dude wrote:Confirmed -- if you want to use HugePages for your SGA, you can't use AMM. You can however (as you've proved) use both on the same machine for different DB instances.
It seems I have been misinterpreting the information of AMM being incompatible with kernel hugepages. I was under the false impression that using /dev/shm or kernel hugepages was mutually exclusive, applying to the server, but it only applies to the DB instance. Can someone confirm this?
Hugepages Not used when ASM is used (Doc ID 1457842.1).
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168
Followed Note 361468.1 - HugePages on Oracle LInux 64-bit but Oracle is still not using hugepages.
The RDBMS not using huge pages was because the ASM home was still using AMM. This is the default for an ASM instance. Please refer to Note: 749851.1 - HugePages and Oracle Database 11g Automatic Memory Management (AMM) on Linux.
Make sure the ASM home not using AMM.
I am apparently missing something here. My translation of the doc id above is that the ASM instance cannot use AMM if you want the RDBMS instance to use HugePages. So if you have an RDBMS instance using AMM then it must NOT be using ASM and will not be using hugepages. If I have it wrong then please explain Doc ID 1457842.1.