Re: Questions about performance tuning rules of thumb

In article <6el18b$qqg$1_at_news.metrobbs.com>, x <xenophon_at_usa.net> wrote:
>
>We are looking into optimizing i/o performance for a data warehouse running
>Oracle 7.3.3 on HP/UX 10.3. Are these rules of thumb reasonable for
>warehouses?
>
>1) The more memory the better. Oracle loves memory. Is there a
>relationship with lots of memory improving certain types of read performance
>for system tables? Should the SGA be set as large as possible? I hear
>this commonly in the AIX world.

It should be set as large as possible without setting off swapping. That may mean 1/3 to 1/2 of physical.

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!