Re: Passing the Windows Memory Limits

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<8vas6vob2l8uem8tvadand8gl36okuk672_at_4ax.com>...
> On Tue, 11 Mar 2003 09:59:21 -0800, Chuck <ccarson_at_echeeba.com> wrote:
>
> > Is there anyway to prevent this behavior?
>
> Sure: use a real operating system.
> According to Metalink Winblows *by design* uses 50 percent RAM with a
> minimum of 1G. So using 4G should be fully impossible.
>
> The other solution of course is to tune the 3rd party application
> before starting to throw memory.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Sybrand,

winblows it up your rectum. repeatedly.
the same memory limitations kick in if one is running linux on IA-32.

turn off the file cache and disable the services that you're not going to use.
the ratio 41% is commonly known as to what NT4/W2K allocate to filesystem caching in memory. do what any good DBA would do and turn it off.

I would not trust metalink as to how much memory W2K Advanced Server uses.
I'd use something like "c:\> pslist -m" - or does the use of a command prompt scare you?

Boot options can be set in boot.ini to enable large memory support. (/3GB, /PAE)
This is covered very well in the book:
"Oracle9i for Windows 2000 Tips & Techniques" Scott Jesse, Matthew Sale.

and in docs in Metalink.

I have used the /3GB boot option with success (until the 8.1.7.4.1 patchset).

I have not used indirect_block_buffers, but if used, could allow an SGA of 7 GB
(3 GB under the 4 GB mark in physical memory and 4 GB of extended memory using PAE). This is cpu functionality, so if you decide to install your favorite Linux distibution on IA32, the same limitations/workarounds apply.

Check out how inexpensive it is to get a Dell PE 6650 with 8 GB of memory.
1 GB DIMMs are cheap - its the 2 GB DIMMs that are pricey.

Paul Received on Fri Mar 14 2003 - 00:46:26 CST