V$IOFUNCMETRIC definition in Oracle Database 11.2
V$IOFUNCMETRIC

SELECT
  begin_time,                              -- BEGIN_TIME DATE
  end_time,                                -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  function_id,                             -- FUNCTION_ID NUMBER
  function_name,                           -- FUNCTION_NAME VARCHAR2(18)
  small_read_mbps,                         -- SMALL_READ_MBPS NUMBER
  small_write_mbps,                        -- SMALL_WRITE_MBPS NUMBER
  large_read_mbps,                         -- LARGE_READ_MBPS NUMBER
  large_write_mbps,                        -- LARGE_WRITE_MBPS NUMBER
  small_read_iops,                         -- SMALL_READ_IOPS NUMBER
  small_write_iops,                        -- SMALL_WRITE_IOPS NUMBER
  large_read_iops,                         -- LARGE_READ_IOPS NUMBER
  large_write_iops,                        -- LARGE_WRITE_IOPS NUMBER
  avg_wait_time                            -- AVG_WAIT_TIME NUMBER
FROM
  gv$iofuncmetric
WHERE
  inst_id = USERENV('INSTANCE')

home |  up