Find Hourly Archival Generation for a given day

Find Hourly Archival Generation for a given day in a Oracle Database instance ----------------------------------------------------------------------------- set linesize 1000 pagesize 10000 alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss'; select round(FIRST_TIME,'hh') ,count(distinct THREAD#||SEQUENCE#),sum(blocks*BLOCK_SIZE)/1024/1024/1024 from v$archived_log where first_time >=trunc(<>) group by round(FIRST_TIME,'hh') order by 1 asc;