ADDM Reports Significant virtual memory paging was detected on the host operating system

Our Oracle server runs on Linux x86-64 with 24GB of RAM and 10GB SGA.

The ADDR Reports on DBConsole show this message:

Significant virtual memory paging was noticed on the host operating system.
The host was experiencing paging, but no clear cause was found.

After checking the meta-link, I found that this is normal behavior for Windows. However, on 64-bit Linux, SGA > 10g can cause this issue.

Referring to the meta link on HugePages for Oracle Linux 64-bit [ID 361468.1], it states that if your total database SGAs exceed 8GB, you must configure HugePages.

But another note, “HugePages and Oracle Databases 11g Automatic Memory Management (AMM) on Linux [ID 749851.1],” talks about how the AMM feature from Oracle 11g works together with the HugePages feature of the Linux OS kernel.

When the 11g AMM feature is enabled by the MEMORY_TARGET/MEMORY_MAX_TARGET parameters, HugePages cannot be used. AMM and HugePages are not compatible. To use HugePages, ensure both settings are disabled.

The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are not set (use ALTER SYSTEM RESET).