V$FILEMETRIC_HISTORY definition in Oracle Database 11.2
V$FILEMETRIC_HISTORY

SELECT
  begin_time,                              -- BEGIN_TIME DATE
  end_time,                                -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  file_id,                                 -- FILE_ID NUMBER
  creation_time,                           -- CREATION_TIME NUMBER
  average_read_time,                       -- AVERAGE_READ_TIME NUMBER
  average_write_time,                      -- AVERAGE_WRITE_TIME NUMBER
  physical_reads,                          -- PHYSICAL_READS NUMBER
  physical_writes,                         -- PHYSICAL_WRITES NUMBER
  physical_block_reads,                    -- PHYSICAL_BLOCK_READS NUMBER
  physical_block_writes                    -- PHYSICAL_BLOCK_WRITES NUMBER
FROM
  gv$filemetric_history
WHERE
  inst_id = USERENV('INSTANCE')

home |  up