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')