Gv$iostat_file and v$iostat_file views
Hi All!
I'm a little bit confused about the relation between Gv$iostat_file and v$iostat_file views.
I have a four node rac 11gr2 database.
There is ASM on shared disks; When i check the async I/O on datafiles the v$iostat_file and gv$iostat_file views show different results:
The instance id where i checked is the 2.
select inst_id from gv$instance g, v$instance v where v.instance_name=g.instance_name;
INST_ID
----------
2
The query result from V$ views:
SQL> SELECT f.status,f.enabled,file# FROM V$DATAFILE F,V$IOSTAT_FILE I
0