Re: Significant virtual memory paging was detected on the host operating system

On Nov 5, 4:10 pm, chris <cboi..._at_jlr.ca> wrote:
> Hi everyone,
>
> Id' just setup a new server for our Database, here's the Spec :
>
> Win Server 2003 Ent. Edition (64 bit)
> 2 CPUs
> 24 Gb of RAM
> Oracle 10.0.2.3 (64 bit)
>
> My SGA is 11040 MB and the PGA 4095 MB
> so, around 17GB for the instance, and it left 7GB of RAM for the OS
> suppose to be Ok, but i have the message : Significant virtual memory
> paging was detected on the host operating system in the EM ...
>
> Do i do something wrong ?
>
> Thanks
> Chris

The message may be a false alarm - even checking task manager on Windows 2003 may be misleading. On Windows 2003, the "PF Usage" statistic in task manager is not page file usage, but instead total virtual memory usage, which includes RAM and page file. Oracle Enterprise Manager, I believe, is showing the "PF Usage" statistic. For additional information see the discussion in this link: http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/b62c4d761cace2a6

Joel provides a good suggestion regarding a starting point for memory allocation.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Nov 05 2007 - 20:08:00 CST