Ah Ming wrote:
> 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
There is no such thing as ideal. If there was DBAs wouldn't spend time
tuning would they? What is required here is called work. Learn to use
the V$ magic views. Learn to use explain plan. Learn to use
DBMS_PROFILER. Learn to use TKPROF and Trace Analyzer. Learn Oracle.
--
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 Sun Mar 07 2004 - 22:30:38 CST
