SELECT
  FUNCTION_ID,                             -- FUNCTION_ID NUMBER
  FUNCTION_NAME,                           -- FUNCTION_NAME VARCHAR2(18)
  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
  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_DETAIL
where
  inst_id=USERENV('Instance')