Archive log report

SQL> alter session set nls_date_format = 'YYYY-MM-DD HH24';

Session altered.

SQL>

select trunc(COMPLETION_TIME,'HH24') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,'HH24') order by 1;

TIME              SIZE_MB
------------- ----------------------------
2015-07-04 11             19.5673828
2015-07-06 12              4.00683594
2015-07-12 07             55.2021484
2015-07-12 08             1.97949219
2015-07-20 09             49.2480469
2015-07-22 10             22.5185547