Re: High diskread ? why ?

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 Received on Wed Apr 22 1998 - 01:19:12 CDT