Re: Oracle 10g on Windows 2003 x64 Memory Useage

On Aug 10, 3:00 am, hjr.pyth..._at_gmail.com wrote:
> On Aug 3, 9:09 pm, Charles Hooper <hooperc2..._at_yahoo.com> 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?
>
> > Charles Hooper
> > IT Manager/Oracle DBA
> > K&M Machine-Fabricating, Inc.
>
> Apart from that useful bit of advice, be warned that 64-bit Oracle on
> 64-bit Windows 2003 that runs on AMD processors will experience a
> massive performance hit as memory starts paging maniacally once total
> memory consumption hits about 12.8GB. It's a known bug, there's a TAR
> out on it, it's allegedly fixed in 10.2.0.3 (not yet tested, however),
> and it only affects AMD processor platforms.
>
> Might not have any relevance to the OP, but I thought I'd mention it
> just in case...

Thanks for posting the above. Interesting - I wonder if this issue/ inconsistency is a bit more widespread/different than Oracle believes. My servers have Intel processors. System performance is great, so I am not too concerned about the inconsistent numbers. But, if there is a real problem...

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Fri Aug 10 2007 - 06:40:26 CDT