SELECT
  FILE_NO,                                 -- FILE_NO NUMBER
  FILETYPE_ID,                             -- FILETYPE_ID NUMBER
  FILETYPE_NAME,                           -- FILETYPE_NAME VARCHAR2(28)
  SMALL_READ_MEGABYTES,                    -- SMALL_READ_MEGABYTES NUMBER
  SMALL_WRITE_MEGABYTES,                   -- SMALL_WRITE_MEGABYTES NUMBER
  LARGE_READ_MEGABYTES,                    -- LARGE_READ_MEGABYTES NUMBER
  LARGE_WRITE_MEGABYTES,                   -- LARGE_WRITE_MEGABYTES NUMBER
  SMALL_READ_REQS,                         -- SMALL_READ_REQS NUMBER
  SMALL_WRITE_REQS,                        -- SMALL_WRITE_REQS NUMBER
  SMALL_SYNC_READ_REQS,                    -- SMALL_SYNC_READ_REQS NUMBER
  LARGE_READ_REQS,                         -- LARGE_READ_REQS NUMBER
  LARGE_WRITE_REQS,                        -- LARGE_WRITE_REQS NUMBER
  SMALL_READ_SERVICETIME,                  -- SMALL_READ_SERVICETIME NUMBER
  SMALL_WRITE_SERVICETIME,                 -- SMALL_WRITE_SERVICETIME NUMBER
  SMALL_SYNC_READ_LATENCY,                 -- SMALL_SYNC_READ_LATENCY NUMBER
  LARGE_READ_SERVICETIME,                  -- LARGE_READ_SERVICETIME NUMBER
  LARGE_WRITE_SERVICETIME,                 -- LARGE_WRITE_SERVICETIME NUMBER
  ASYNCH_IO,                               -- ASYNCH_IO VARCHAR2(9)
  ACCESS_METHOD,                           -- ACCESS_METHOD VARCHAR2(11)
  RETRIES_ON_ERROR                         -- RETRIES_ON_ERROR NUMBER
FROM
  GV$IOSTAT_FILE
where
  inst_id=USERENV('Instance')