GV$FILE_HISTOGRAM
select k.inst_id, -- INST_ID NUMBER k.kcfiofno, -- FILE# NUMBER k.kcfiomaxdur, -- SINGLEBLKRDTIM_MILLI NUMBER k.kcfioval -- SINGLEBLKRDS NUMBER from x$kcfiohist k, x$kccfe f where f.fedup <> 0 and f.fenum=k.kcfiofno

home |  up  |  mailbox