Re: Multi-Block read count

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 11 Jan 2002 08:01:09 -0800
Message-ID: <bde5777e.0201110801.52f6b1b1@posting.google.com>

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