DBA Data[Home] [Help]

VIEW: SYS.V_$FILEMETRIC

Source

View Text - Preformatted

select "BEGIN_TIME","END_TIME","INTSIZE_CSEC","FILE_ID","CREATION_TIME","AVERAGE_READ_TIME","AVERAGE_WRITE_TIME","PHYSICAL_READS","PHYSICAL_WRITES","PHYSICAL_BLOCK_READS","PHYSICAL_BLOCK_WRITES","CON_ID" from v$filemetric
View Text - HTML Formatted

SELECT "BEGIN_TIME"
, "END_TIME"
, "INTSIZE_CSEC"
, "FILE_ID"
, "CREATION_TIME"
, "AVERAGE_READ_TIME"
, "AVERAGE_WRITE_TIME"
, "PHYSICAL_READS"
, "PHYSICAL_WRITES"
, "PHYSICAL_BLOCK_READS"
, "PHYSICAL_BLOCK_WRITES"
, "CON_ID"
FROM V$FILEMETRIC