Re: Oracle running in a Windows 2000 Adv server more than 4G RAM

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 05 Mar 2004 23:39:34 -0800
Message-ID: <1078558739.21393@yasure>

Brian Peasland wrote:

>>What do you mean I can't believe run perfectly well in
>>2GB of RAM?

>
>
> He means...why are you going through the trouble of making your Oracle
> database use more than 2GB of RAM on a Windows server? Do you now for a
> fact that you need more than 2GB allocated to your SGA? Many, many
> databases need less than 2GB. Have you tried a SGA less than 2GB in
> size?
>
> HTH,
> Brian

Exactly. It seems to me that you are one of those people that thinks more is better. So if you have 8GB of RAM you feel compelled to use it. I would argue the exact opposite. It might well be that a larger SGA would make things run more slowly.

Don't put any effort into trying to spoof Windows unless you have a compelling reason to move beyond the default. And by that I mean hard numbers from real-time analysis.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Mar 06 2004 - 01:39:34 CST