Memory problems, Oracle 10, Win 2003 (32 bit)

From: mike.reid <chmonkey_at_gmail.com>
Date: Sun, 15 Jun 2008 09:26:40 -0700 (PDT)
Message-ID: <5503e537-f8f0-44ad-8fb8-24d4f4924d87@y38g2000hsy.googlegroups.com>


I was hoping to get some assistance from the group....

I am working with a client who is running into some memory problems with their Oracle database.

Now I am not an expert by a long shot, but the application vendor has told us that their rule of thumb is to always force a pagefile that is 2.5 times the physical memory (so 10gb in this case).

My understanding on the subject was that because Oracle is "Opportunistic" with its memory usage that you actually want to pretty much disable the pagefile altogether so that Oracle does use it.

Just taking a look at the server seems to tell that Oracle is using about 800mb of physical and 1.7gb total. Is it reasonable in your opinion to run a test and disable the pagefile all together?

Any help that anyone can give me would be greatly appreciated!

Mike Received on Sun Jun 15 2008 - 11:26:40 CDT

Original text of this message