GV$FILEMETRIC_HISTORY definition in Oracle Database 11.2
GV$FILEMETRIC_HISTORY

SELECT
  inst_id,                                 -- INST_ID NUMBER
  begtime,                                 -- BEGIN_TIME DATE
  endtime,                                 -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  fileid,                                  -- FILE_ID NUMBER
  creationtime,                            -- CREATION_TIME NUMBER
  avrdtime,                                -- AVERAGE_READ_TIME NUMBER
  avwrtime,                                -- AVERAGE_WRITE_TIME NUMBER
  phyread,                                 -- PHYSICAL_READS NUMBER
  phywrite,                                -- PHYSICAL_WRITES NUMBER
  phybkrd,                                 -- PHYSICAL_BLOCK_READS NUMBER
  phybkwr                                  -- PHYSICAL_BLOCK_WRITES NUMBER
FROM
  x$kewmflmv

home |  up