Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-Block read count
Jonathan,
do you have - regarding this - pointers to relevant v$-views, parameters or oracle doc?
> Oracle has taken note of this in Oracle 9 by
> allowing you to collect "system statistics"
> over a typical time period so that it can incorporate
> I/O rates into its costing calculations. The interesting
> thing to note is that it records three things for I/O
>
> Average time for a single block read over the period.
>
> Average time for a multi block read over the period.
>
> Average ACTUAL size requested for a multiblock read
> over the period.
Kind Regards,
Herman de Boer. Received on Fri Jan 11 2002 - 10:01:09 CST