Re: Oracle 10g on Windows 2003 x64 Memory Useage

Charles Hooper wrote:

> Have you enabled large page support on Windows and Oracle, which
> causes Windows to use 4MB memory page sizes rather than 4KB memory
> pages? If so, I suspect that Performance Monitor is showing incorrect
> information. I am running Oracle 10.2.0.2 on Windows 2003 x64, total
> page file size for all drives is configured at 3124MB, yet Task
> Manager reports that PF usage is 13.3GB. In my case, system
> performance is great, so I am not too concerned about the inconsistent
> numbers.
 

> Have you verified that the page file is actually 10GB in size?

I have read quite a few of your posts and I think that:

1. you know what you're talking about

and

b) you genuinely try to help people.

I hope that this info can help you and/or others.

For Windows, there is a nifty/cool/rad/awesome(for Yanks only) - (choose term which hasn't gone out of fashion, or better yet, the one which has come back into fashion!!)

Go to www.sysinternals.com and go for procexp (process explorer).exe - it gives more reliable results than the Windows performance monitor.

Inconsistent numbers should not happen. The site also has a number of other useful bits and bobs for anyone concerned with performance.

Paul...  

> Charles Hooper
Received on Thu Aug 09 2007 - 17:14:05 CDT