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

On 6 Mar 2004 06:37:18 -0800, leo_at_tech-trans.com (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

You seem to subscribe to the 'more is better' school of tuning, in order to make up for not being capable to design a proper normalized and tuned database. You are starting from the wrong end, and soon you will find out your 'method' doesn't work.

--
Sybrand Bakker, Senior Oracle DBA