Re: IO-TIME in V$FILESTAT
Date: Wed, 1 Dec 2021 12:29:17 -0800
Message-ID: <CAORjz=PgyFNVUXxkW+s_gH_QqEft=LQjSACVxJhq6ed-2_8Z2Q_at_mail.gmail.com>
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_at_sleepnumber.com>
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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 01 2021 - 21:29:17 CET