Verifica Quantidade de Archives Gerados por Hora

set feedback off
set timing on
alter session set nls_date_format='dd/mm/yy';
set pagesize 80 lines 200
col 00 for a4
col 01 for a4
col 02 for a4
col 03 for a4
col 04 for a4
col 05 for a4
col 06 for a4
col 07 for a4
col 08 for a4
col 09 for a4
col 10 for a4
col 11 for a4
col 12 for a4
col 13 for a4
col 14 for a4
col 15 for a4
col 16 for a4
col 17 for a4
col 18 for a4
col 19 for a4
col 20 for a4
col 21 for a4
col 22 for a4
col 23 for a4
select     trunc(first_time) day
    ,to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)), '999') "00"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)), '999') "01"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)), '999') "02"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)), '999') "03"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)), '999') "04"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)), '999') "05"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)), '999') "06"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)), '999') "07"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)), '999') "08"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)), '999') "09"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)), '999') "10"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)), '999') "11"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)), '999') "12"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)), '999') "13"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)), '999') "14"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)), '999') "15"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)), '999') "16"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)), '999') "17"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)), '999') "18"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)), '999') "19"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)), '999') "20"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)), '999') "21"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)), '999') "22"
    ,to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)), '999') "23"
from gv$log_history
where first_time > trunc(sysdate -5)
and first_time < sysdate + 1
group by trunc(first_time)
order by 1;