V$WAITSTAT

Data Dictionary View

Columns
   ___________________________
 
   CLASS
   COUNT
   TIMEs

A related X$ view worth looking at is X$KCBFWAIT:
columns:
ADDR
INDX
COUNT
TIME

You can use this to display Buffer Waits per file
(run as SYS)
SELECT count, time, name
FROM v$datafile df, X$KCBFWAIT fw
WHERE fw.indx+1 = df.file#;

Related:

V$DATAFILE
V$FILESTAT


© Copyright SS64.com 1999-2013
Some rights reserved