Hi,
We've recently installed a new Oracle RAC database at a client site:
2-nodes x Windows 2003 R2 Standard x64 SP2
Oracle 10.2.0.6.0 64-bit
Each node has 16Gb of RAM
SGA_TARGET = 1536M
PGA_AGGREGATE_TARGET=1628M
Browsing through Enterprise Manager, there was a warning about "Excessive Virtual Memory Paging". So I opened Windows Task Manager on one of the nodes and yes, I am seeing huge numbers for "page faults" for the oracle.exe process. To give a slightly better idea, the values of some pertinent columns for this process as I write are:
Proc Name Memory Use Max Mem Use Virtual Mem Size Page Faults
oracle.exe 2.690.692KB 2.959.324KB 3.053.889KB 2.914.171.009
And that value for "page faults" is increasing by about 1000-2000 a second.
There are several other processes running on the server, nothing appears out of the ordinary to me (e.g. processes for Enterprise Manager, AntiVirus, winlogon.exe). The sum of the memory these processes are using/have used is about 1Gb.
Looking at the "performance" tab in Task Manager, I see that:
Total Physical Memory = 16Gb
Available = 12Gb
All of that makes sense to me:
16Gb RAM
4Gb used by all processes on the server
12Gb available
So why do we see so much paging for oracle.exe? I guess I'm missing something about what exactly the "page faults" column is telling me. Can anyone explain what's going on?
Regards,
Ados