Home » RDBMS Server » Performance Tuning » Virtual Memory Paging (Oracle Windows Server 2003 EE)
Virtual Memory Paging [message #418509] Sun, 16 August 2009 17:18 Go to next message
Messages: 9
Registered: August 2009
Location: dd
Junior Member

Oracle Windows Server 2003 EE (16GB Physical RAM)
Virtual Memory:
Initial Size:16.4GB
Maximum Size: 20GB

I create ADDM report and:

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

RECOMMENDATION 1: Host Configuration, 100% benefit (50400 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.

When users don't work in Task Manager I see:
Mem usage: 1.3GB
Page Fault: 2.4GB

[Updated on: Sun, 16 August 2009 17:28]

Report message to a moderator

Re: Virtual Memory Paging [message #418510 is a reply to message #418509] Sun, 16 August 2009 17:38 Go to previous message
Messages: 25579
Registered: January 2009
Location: SoCal
Senior Member
>When users don't work
What does this mean?

>Oracle Windows Server 2003 EE (16GB Physical RAM)
>Virtual Memory:
>Initial Size:16.4GB
>Maximum Size: 20GB
Why does Initial Size exceed Physical RAM size?

How will an independent observer know when your issue has been resolved?

[Updated on: Sun, 16 August 2009 18:05]

Report message to a moderator

Previous Topic: Bitmap & Normal Index for same column - Oracle
Next Topic: Open cursor count is too high
Goto Forum:

Current Time: Wed Aug 23 09:05:02 CDT 2017

Total time taken to generate the page: 0.07210 seconds