Re: Oracle 10g on Windows 2003 x64 Memory Useage

On Aug 2, 9:22 am, sev..._at_kcpweb.net wrote:
> Hi All,
>
> We are running Oracle 10g on a Quad Dual Core Windows 2003 x64
> Enterprise Server with 16GB of memory. I notice that the Oracle
> process is only using 4.6 GB of Physical RAM and 10GB of Virtual
> memory. Performance monitor is showing that the server has 8GB
> Physical Memory free. This seems like oracle isn't using the free
> memory very efficiently and swapping a lot out to disk, is this
> something that can be tuned to boost performance or is it dynamically
> performed by the Oracle process?
>
> Thanks for your help, I'm new to Oracle having worked mainly with MS
> SQL so go easy on me,
>
> Regards,
>
> Stephen

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. Received on Fri Aug 03 2007 - 06:09:54 CDT