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

Oracle 10.2.0.4g 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:
Oracle.exe
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
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>When users don't work
What does this mean?

>Oracle 10.2.0.4g 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: Blocking Session - blocked SQL -> SELECT SYSDATE FROM SYS.DUAL
Next Topic: Open cursor count is too high
Goto Forum:
  


Current Time: Fri Nov 22 13:03:52 CST 2024