Re: IO Details || ORCL

Hi,

I usually look at an AWR from a busy time (you can use CPU time spend as indicator) and look at the I/O related wait events. It is good to look at the averages and the histogram to find out how well your I/O subsystem works.

Thanks

Lothar

Am 15.07.2023 um 05:34 schrieb Krishnaprasad Yadav:
> Hi Gurus,
>
> Currently wanted to know more about below :
>
> How to calculate read response time for a single block and for
> multiple blocks for an oracle database ?
> i tried certain research  from different website , we see only metric
> is about :   'Average Synchronous Single-Block Read Latency'  , i
> can't get any further details  ,  Are Average Synchronous Single-Block
> Read Latency can be used to calculate the IO-throughput from database .
>
> Regards,
> Krishna

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