oracle中查看每天的归档日志大小

--查看每天产生的归档日志大小：

select aa.ArchiveDate,aa.ArchiveSize from (
select trunc(first_time) as ArchiveDate,
sum(block_size * blocks) / 1024 / 1024 / 1024 as ArchiveSize
from v$archived_log
group by trunc(first_time)
) aa order by aa.ArchiveDate desc