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