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