V$FILE_OPTIMIZED_HISTOGRAM definition in Oracle Database 11.2
V$FILE_OPTIMIZED_HISTOGRAM

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

home |  up