← Redo & Archive Logs
Oracle · Redo & Archive Logs

How to check archive log generation per day in Oracle

Check Oracle archive log generation per day: volume in GB and count, per thread.

Tested on11g12c19c21c23ai26ai

Run against the database instance.

set pages 1000
select trunc(COMPLETION_TIME,'DD') Day, thread#, 
round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB,
count(*) Archives_Generated from v$archived_log 
group by trunc(COMPLETION_TIME,'DD'),thread# order by 1;
archivelogredov$archived_log