Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

High swap file utilization - 11g on windows 2003 x64

519674Nov 26 2008 — edited Nov 26 2008

Hi,
I'm running database 11.1.0.6 patch set 10 on
Windows Server 2003 x64 standard
HP DL380 dual quad core + 8GB RAM
2 x 72GB 15K SAS mirror for OS
6 x 72GB 15k SAS RAID-5 for data + logs (i know ideally logs need to move to a RAID-1 set etc)

dedicated mode
database is about 10GB (main set of tables about 1GB)
SGA + PGA 4GB (auto memory management)
server has been set to network application mode such that less mem is allocated to the system cache etc.
Large Page support has been enabled (not confirmed if this is working, any ideas how to?)

Looking at the page faults and page out perf mon stats it looks too high/ too much given the arrangement above. The majority of the page faults are coming from the Oracle.exe process. But I cannot explain why specially if Large Page is setup then the SGA etc should be locked in to RAM as I understand.

side note I was seeing similar behaviour on the older 10.2.0.1 DB that had same mem config for the same set of data.

Any ideas people?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2008

Added on Nov 26 2008

#11g, #general-database-discussions, #memory, #windows

4 comments

2,952 views