按天统计 Oracle 数据库归档日志的大小

set lines 200 pages 50000
select
    to_char(completion_time, 'YYYY-MM-DD') as archivelog_date,
    round(sum(blocks * block_size) / 1024 / 1024 / 1024, 2) as archivelog_size_gb
from
    gv$archived_log
where
    to_char(completion_time, 'YYYY-MM-DD') BETWEEN to_char(sysdate-31, 'YYYY-MM-DD') AND to_char(sysdate, 'YYYY-MM-DD')
group by
    to_char(completion_time, 'YYYY-MM-DD')
order by
    to_char(completion_time, 'YYYY-MM-DD');