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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 06 Mar 2004 08:04:29 -0800
Message-ID: <1078589034.884883@yasure>

Ah Ming wrote:

> Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<40493DA3.9DB530F3_at_remove_spam.peasland.com>...
>

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

>
>
> For what reason(s) that SGA is less than 2GB RAM? Can it apply in any
> operating systems? In the world, database server is less than 2GB
> RAM? Thanks for your recommendation!
>
> Ming

With Windows you can not access more than 2GB of RAM by default

Yes this is true of any operating system. Larger is not necessarily better. Often it can make things slower.

Oracle's memory utilization needs to be determined on an instance by instance basis as an act of intentional tuning. Not just by grabbing every bit of memory the machine can spare.

-- 
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 - 10:04:29 CST