← 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