select
  d.inst_id,                               -- INST_ID NUMBER
  d.instname,                              -- INSTNAME VARCHAR2(64)
  d.dbname,                                -- DBNAME VARCHAR2(8)
  d.group_number,                          -- GROUP_NUMBER NUMBER
  d.disk_number,                           -- DISK_NUMBER NUMBER
  d.failgroup,                             -- FAILGROUP VARCHAR2(30)
  d.reads,                                 -- READS NUMBER
  d.writes,                                -- WRITES NUMBER
  d.read_errs,                             -- READ_ERRS NUMBER
  d.write_errs,                            -- WRITE_ERRS NUMBER
  d.read_time/1000000,                     -- READ_TIME NUMBER
  d.write_time/1000000,                    -- WRITE_TIME NUMBER
  d.bytes_read,                            -- BYTES_READ NUMBER
  d.bytes_written,                         -- BYTES_WRITTEN NUMBER
  d.hreads,                                -- HOT_READS NUMBER
  d.hwrites,                               -- HOT_WRITES NUMBER
  d.hbytes_read,                           -- HOT_BYTES_READ NUMBER
  d.hbytes_written,                        -- HOT_BYTES_WRITTEN NUMBER
  d.creads,                                -- COLD_READS NUMBER
  d.cwrites,                               -- COLD_WRITES NUMBER
  d.cbytes_read,                           -- COLD_BYTES_READ NUMBER
  d.cbytes_written                         -- COLD_BYTES_WRITTEN NUMBER
from
  x$kfnsDskIost d