Archivelog Complete Guide

 ************Daily Archive Log Generation****************
SQL> select trunc(COMPLETION_TIME,'DD') Day, thread#, 
round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB,
count(*) Archives_Generated from gv$archived_log 
group by trunc(COMPLETION_TIME,'DD'),thread# order by 1;
DAY                     THREAD#         GB ARCHIVES_GENERATED
-------------------- ---------- ---------- ------------------
10-OCT-2016 00:00:00          1         19                233
11-OCT-2016 00:00:00          1         34                417
12-OCT-2016 00:00:00          1         42                522
*************Hourly Archive Log Generation****************
set pages 1000
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
select trunc(COMPLETION_TIME,'HH') Hour,thread# , 
round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB,
count(*) Archives from gv$archived_log 
group by trunc(COMPLETION_TIME,'HH'),thread#  order by 1 ;


HOUR         THREAD#         GB   ARCHIVES
--------- ---------- ---------- ----------
18-MAR-23          1          0          1
18-MAR-23          1          0          1
18-MAR-23          1          2          5
18-MAR-23          1          0          2
*****************************************************