if the database is using ASM, use gv$asm_disk_iostat
When connected to the ASM instance, that view provides stats for all
instances of all databases, by disk.
On Fri, Nov 19, 2021 at 09:41 Hameed, Amir <amir.hameed@xxxxxxxxxxxxxxx>
wrote:
Hi,--
I would like to ask a general question. How reliable are READTIM,
SINGLEBLKRDTIM, AVGIOTIM statistics in V$FILESTAT in 11.2.0.4 and 12.1.0.2?
I vaguely remember someone had advised me a while ago not to rely on these
statistics.
Any feedback will be appreciated.
Thanks,
Amir