检查oracle数据库每日归档日志生成量

select trunc(completion_time) as "Date",
       count(*) as "Count",
	   (sum(blocks * block_size))/1024/1024 as "MB"
from v$archived_log
group by trunc(completion_time)
order by trunc(completion_time);