Query to Display Archive Log Generation by Day in Oracle

SET PAGESIZE 70
SET LINESIZE 400

COL “Generation Date” FORMAT a30

SELECT TRUNC(completion_time)  “Generation Date” ,
round(SUM(blocks*block_size)/1048576,0) “Total for the Day in MB”
FROM gv$archived_log
GROUP BY TRUNC(completion_time)
ORDER BY TRUNC(completion_time)
/