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

?

1 2 3 4 5 6

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);