SELECT TRUNC(first_time) AS day,
ROUND(SUM(blocks * block_size)/1024/1024/1024,2) size_gb
FROM v$archived_log
WHERE TRUNC(first_time) >= TRUNC(SYSDATE) – &1
GROUP BY TRUNC(first_time)
ORDER BY TRUNC(first_time);

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.