select
  instname,                                -- INSTNAME VARCHAR2(64)
  dbname,                                  -- DBNAME VARCHAR2(8)
  group_number,                            -- GROUP_NUMBER NUMBER
  disk_number,                             -- DISK_NUMBER NUMBER
  failgroup,                               -- FAILGROUP VARCHAR2(30)
  reads,                                   -- READS NUMBER
  writes,                                  -- WRITES NUMBER
  read_errs,                               -- READ_ERRS NUMBER
  write_errs,                              -- WRITE_ERRS NUMBER
  read_time,                               -- READ_TIME NUMBER
  write_time,                              -- WRITE_TIME NUMBER
  bytes_read,                              -- BYTES_READ NUMBER
  bytes_written,                           -- BYTES_WRITTEN NUMBER
  hot_reads,                               -- HOT_READS NUMBER
  hot_writes,                              -- HOT_WRITES NUMBER
  hot_bytes_read,                          -- HOT_BYTES_READ NUMBER
  hot_bytes_written,                       -- HOT_BYTES_WRITTEN NUMBER
  cold_reads,                              -- COLD_READS NUMBER
  cold_writes,                             -- COLD_WRITES NUMBER
  cold_bytes_read,                         -- COLD_BYTES_READ NUMBER
  cold_bytes_written                       -- COLD_BYTES_WRITTEN NUMBER
from
  gv$asm_disk_iostat
where
  inst_id = USERENV('Instance')