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

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<iduj40dvv1qvhkuf4imrnao994ko92718n_at_4ax.com>...
> 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.

Do you have any ideal or reference for SGA tunning when the database is using for POS use. Thanks for your suggestion at all!

Ming Received on Sun Mar 07 2004 - 19:09:21 CST