Re: High diskread ? why ?

Hi Matthias,

What is the basis for your recommendation for SGA size vs server RAM?

I could be wrong (I often am), but I would think that in OLAP applications that you could go to a much higher percentage of RAM since you have fewer users (typically) and much larger tables.

Also what about situations when the server RAM is 1GB or more?

Regards

Jerry

Matthias Gresz wrote:
>
> Hi,
>
> I'd check the size of the SGA, especially the number of db-blocks and
> the sort area size. Increase as much as possible, but keep in mind that
> SGA shoudn't take more than 1/3 to 1/2 of server's RAM if running on NT,
> for UNIX it may differ.
>
> andrewl_at_tnl.com.au schrieb:
> >
> > What causes high diskread per execution ?
> >
> > Is the order of tables referrenced on the from clause make a different ?
> >
> > Thanks,
> > Andrew L
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
> --
>
> Regards
>
> Matthias Gresz :-)
>
> GreMa_at_t-online.de

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group