Re: average multiblock read size

From the reference, physical read total bytes is "Total size in bytes of disk reads by all database instance activity including application reads, backup and recovery, and other utilities. The difference between this value and "physical read bytes" gives the total read size in bytes by non-application workload."

So I would assume this includes controlfile and redo reads as they are part of backup and recovery and other utilities.

Physical Read Bytes is "Total size in bytes of all disk reads by application activity (and not other instance activity) only". I would interpret this as pure dbwr and end user SQL IO.

-Gopal

> PS anyone know what kinds of I/O is included in "physical read total
> bytes" - seems to include data block reads , control file reads and redo
> reads
>
>
> - Kyle
> http://dboptimizer.com
>
>

--
http://www.freelists.org/webpage/oracle-l