Verifica Archives Gerados por Dia

set lines 200 pages 200
set timing on;
select    
    trunc(first_time) day
    ,to_char(sum(blocks * block_size)/1024/1024,'999G999D99') MB
from gv\$archived_log
where first_time > trunc(sysdate) -30
and first_time < sysdate +1
group by trunc(first_time)
order by 1 desc;