oracle-wiki.net - Show Archive Log generation By Day

The New Home of Oracle-wiki.net

All things oracle...

A website for IT Professionals involved with Oracle database.

Back

Show Archive Log Generation By Day

-- Display Archive Log Generation by Day

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SET VERIFY OFF

COL "Generation Date" FORMAT a20

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)

Notes

Use this script to review the volume of archived redo logs generated each day. It summarises the total archive log size (in MB) based on the archive log completion date, providing a simple view of daily redo generation.

This report is useful for monitoring redo activity and identifying trends in database workload. It can help with capacity planning for archive log storage, estimating backup requirements, investigating periods of unusually high redo generation, and identifying changes in application or transaction activity over time.

Published on

Published 9th July 2026

Page updated

Google Sites

Report abuse