sevans@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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org