Virtual memory paging was detected in ADDM Report

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

Our oracle server is running on Linux x86-64, 24GB RAM. SGA 10GB.

The ADDR Reports on DBConsole displays this message:

Significant virtual memory paging was detected on the host operating system.
Host operating system was experiencing significant paging but no particular root cause could be detected.

After searching in meta-link, I found that this is expected behavior for windows operating system. But, for 64-bit Linux, SGA>10g tend to cause this problem.

Referring to this meta link note HugePages on Oracle Linux 64-bit [ID 361468.1], it says if your combined database SGAs is large (more than 8GB), You will need HugePages configured.

But another metalink note “HugePages and Oracle Databaes 11g Automatic Memory Management (AMM) on Linux [ID 749851.1]” discusses the inteoperability of the Automatic Memory Management (AMM) feature introduced by Oracle 11g and the HugePages feature of Linux OS kernel.

Whenever 11g AMM feature is enabled by MEMORY_TARGET/MEMORY_MAX_TARGET parameters, HugePages are not used. The use of AMM is absolutely incompatible with HugePages. If you want to use HugePages make sure both

MEMORY_TARGET/MEMORY_MAX_TARGET parameter are unset (ALTER SYSTEM RESET)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.