Database - RAC/Scalability (MOSC)

MOSC Banner

Gv$iostat_file and v$iostat_file views

edited Oct 29, 2012 9:44AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered ✓
  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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center