SELECT
  CONSUMER_GROUP_ID,                       -- CONSUMER_GROUP_ID NUMBER
  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_CONSUMER_GROUP
where
  inst_id=USERENV('Instance')