V$FILE_HISTOGRAM definition in Oracle Database 11.2
V$FILE_HISTOGRAM

select
  FILE#,                                   -- FILE# NUMBER
  SINGLEBLKRDTIM_MILLI,                    -- SINGLEBLKRDTIM_MILLI NUMBER
  SINGLEBLKRDS                             -- SINGLEBLKRDS NUMBER
from
  GV$FILE_HISTOGRAM
where
  inst_id = USERENV('Instance')

home |  up