Re: Passing the Windows Memory Limits

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0303132246.3a45fe25_at_posting.google.com>...
> 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.
>

Obviously I always turn that 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?

No, of course not. However, the command must be from the resource kit. Most of our customers simply don't buy that.

>
> 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.
>

I am aware of that book,and read the chapter on memory architecture. IIRC they are corroborating the Metalink evidence.

> and in docs in Metalink.
>
> I have used the /3GB boot option with success (until the 8.1.7.4.1
> patchset).

The customer I am referring to has Oracle running on plain vanilla Win2k. Not our decision.

>
> 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.

The same customer doesn't want for political reasons to deploy any Unix variant. They don't have Unix knowledge so they would need to transfer full control to my department, which they don't want. The rest of their network of (test, development etc.) databases is on NT.

>
> 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

My company just dumped the CEO and the CFO and is about broke.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Mar 14 2003 - 06:21:46 CST