วันอังคารที่ 14 กรกฎาคม พ.ศ. 2552

ADDM Reports "Significant Virtual Memory Paging Was Detected On The Host Operating System"



Doc ID: 395957.1 Type: PROBLEM
Modified Date : 16-NOV-2006 Status: PUBLISHED

In this Document
Symptoms
Cause
Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
Microsoft Windows

Symptoms

On a Windows system (32 or 64 bit) Automatic Database Diagnostic Monitor (ADDM) reports:

=========================
FINDING 1: 100% impact (858 seconds)
Significant virtual memory paging was detected on the host operating system.

RECOMMENDATION 1: Host Configuration, 100% benefit (858 seconds)
ACTION: Host operating system was experiencing significant paging but no
particular root cause could be detected. Investigate processes that
do not belong to this instance running on the host that are consuming
significant amount of virtual memory. Also consider adding more
physical memory to the host.
=========================



Cause

Expected behavior
The Windows operating system handles virtual memory differently from other operating systems.



Solution

High virtual memory use is not a problem on Windows platforms unless you are experiencing database performance issues.
Therefore, ignore the recommendation/action by ADDM unless you are experiencing database performance issues.

1 ความคิดเห็น: