arc_day

select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB, count(*) Archives_Generated
from v$archived_log
WHERE completion_time >= SYSDATE - &num_days
group by trunc(COMPLETION_TIME,'DD'),thread# order by 1;