DBA Data[Home] [Help]

VIEW: SYS.GV_$IOFUNCMETRIC_HISTORY

Source

View Text - Preformatted

select "INST_ID","BEGIN_TIME","END_TIME","INTSIZE_CSEC","FUNCTION_ID","FUNCTION_NAME","SMALL_READ_MBPS","SMALL_WRITE_MBPS","LARGE_READ_MBPS","LARGE_WRITE_MBPS","SMALL_READ_IOPS","SMALL_WRITE_IOPS","LARGE_READ_IOPS","LARGE_WRITE_IOPS","AVG_WAIT_TIME","CON_ID" from gv$iofuncmetric_history
View Text - HTML Formatted

SELECT "INST_ID"
, "BEGIN_TIME"
, "END_TIME"
, "INTSIZE_CSEC"
, "FUNCTION_ID"
, "FUNCTION_NAME"
, "SMALL_READ_MBPS"
, "SMALL_WRITE_MBPS"
, "LARGE_READ_MBPS"
, "LARGE_WRITE_MBPS"
, "SMALL_READ_IOPS"
, "SMALL_WRITE_IOPS"
, "LARGE_READ_IOPS"
, "LARGE_WRITE_IOPS"
, "AVG_WAIT_TIME"
, "CON_ID"
FROM GV$IOFUNCMETRIC_HISTORY