V$IOSTAT_FUNCTION definition in Oracle Database 11.2
V$IOSTAT_FUNCTION

SELECT
  FUNCTION_ID,                             -- FUNCTION_ID NUMBER
  FUNCTION_NAME,                           -- FUNCTION_NAME VARCHAR2(18)
  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
  LARGE_READ_REQS,                         -- LARGE_READ_REQS NUMBER
  LARGE_WRITE_REQS,                        -- LARGE_WRITE_REQS NUMBER
  NUMBER_OF_WAITS,                         -- NUMBER_OF_WAITS NUMBER
  WAIT_TIME                                -- WAIT_TIME NUMBER
FROM
  GV$IOSTAT_FUNCTION
where
  inst_id=USERENV('Instance')

home |  up