Database Archive Generation report

This post shares Oracle SQL scripts for Redo generation rate:

1. Database Archive Generation report Per Day

select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKS*BLOCK_SIZE)/1048576/1024) GB,
count(*) Archives_Generated from v$archived_log
where COMPLETION_TIME > trunc(sysdate)-&Days
group by trunc(COMPLETION_TIME,'DD'),thread# order by 1

2. Database Archive Generation report Per Hour

set pages 1000
select trunc(COMPLETION_TIME,'HH') Hour,thread# , round(sum(BLOCKS*BLOCK_SIZE)/1048576) MB,count(*)Archives from v$archived_log
group by trunc(COMPLETION_TIME,'HH'),thread# order by 1 ;