GV$TEMP_HISTOGRAM

select
k.inst_id,               -- INST_ID NUMBER
k.kcftiofno,             -- FILE# NUMBER
k.kcftiomaxdur,          -- SINGLEBLKRDTIM_MILLI NUMBER
k.kcftioval              -- SINGLEBLKRDS NUMBER
from
x$kcftiohist k,
x$kcctf f 
where
f.tfdup <> 0 and f.tfnum=k.kcftiofno
home |  up  |  mailbox