Re: IO-TIME in V$FILESTAT

There's also a *V$IOSTAT_FILE* view.
<https://about.me/lcdsantos?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb> Luis Santos
about.me/lcdsantos
<https://about.me/lcdsantos?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>

Em qua., 1 de dez. de 2021 às 17:29, Jared Still <jkstill_at_gmail.com> escreveu:

> 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