How to see IO service time histogram order by Read Time in ms.



col read_time format a9 heading "Read Time|(ms)"
col reads format 999999,99999999,9999999 heading "Reads"
col histogram format a51 heading ""
set pagesize 10000
set lines 100 
set echo on 

SELECT LAG(singleblkrdtim_milli, 1) 
         OVER (ORDER BY singleblkrdtim_milli) 
          || '<' || singleblkrdtim_milli read_time, 
       SUM(singleblkrds) reads,
       RPAD(' ', ROUND(SUM(singleblkrds) * 50 / 
         MAX(SUM(singleblkrds)) OVER ()), '*')  histogram
FROM v$file_histogram
GROUP BY singleblkrdtim_milli
ORDER BY singleblkrdtim_milli; 


Read Time
(ms)                         Reads
--------- ------------------------ ---------------------------------------------------
<1                     660,1811398  *************************************************
1<2                     25,2251982  *
2<4                      4,5348096
4<8                        5699221
8<16                       3959497
16<32                       883079
32<64                       121805
64<128                       10264
128<256                       2963
256<512                       1949
512<1024                      1154
1024<2048                       28


12 rows selected.


Comments