How to check archived redo volume by minute in Oracle

Bucket archived redo by minute for the last N minutes and show total size in MB per bucket. Use it when you need very fine-grained visibility — for example when tracking a redo burst during a batch job.

SET VERIFY OFF PAGESIZE 100

ACCEPT p_minutes NUMBER PROMPT 'How many minutes back: '

WITH mins AS (
  SELECT TRUNC(SYSDATE, 'MI') - (&&p_minutes / (24 * 60))
         + ((level - 1) / (24 * 60)) AS mins
  FROM   dual
  CONNECT BY level <= &p_minutes
)
SELECT m.mins AS date_min,
       ROUND(SUM(blocks * block_size) / 1024 / 1024, 2) AS size_mb
FROM   mins m
LEFT JOIN v$archived_log al ON m.mins = TRUNC(al.first_time, 'MI')
GROUP BY m.mins
ORDER BY m.mins;

SET VERIFY ON PAGESIZE 14