GV$ASM_VOLUME_STAT definition in Oracle Database 11.2
GV$ASM_VOLUME_STAT

select
  xv.inst_id,                              -- INST_ID NUMBER
  xv.group_kfvol,                          -- GROUP_NUMBER NUMBER
  xv.name_kfvol,                           -- VOLUME_NAME VARCHAR2(30)
  xv.compound_kfvol,                       -- COMPOUND_INDEX NUMBER
  xv.volnum_kfvol,                         -- VOLUME_NUMBER NUMBER
  xs.reads_kfvolstat,                      -- READS NUMBER
  xs.writes_kfvolstat,                     -- WRITES NUMBER
  xs.read_errs_kfvolstat,                  -- READ_ERRS NUMBER
  xs.write_errs_kfvolstat,                 -- WRITE_ERRS NUMBER
  xs.read_time_kfvolstat,                  -- READ_TIME NUMBER
  xs.write_time_kfvolstat,                 -- WRITE_TIME NUMBER
  xs.bytes_read_kfvolstat,                 -- BYTES_READ NUMBER
  xs.bytes_written_kfvolstat               -- BYTES_WRITTEN NUMBER
from
  x$kfvol xv,
  x$kfvolstat xs
where
  xv.compound_kfvol = xs.compound_kfvolstat and xs.volnum_kfvolstat <> 0

home |  up