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@xxxxxxxxx>
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@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
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