Re: Oracle 10g on Windows 2003 x64 Memory Useage

sevans_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

What evidence do you have that anything is being swapped to disk?

Go to http://tahiti.oracle.com and search for initialization parameters that related to memory utilization. It is completely configurable. But don't change anything based upon only the information provided above. Bigger does not equal better. You may have just wasted money putting too much RAM in the server.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org