SELECT TRUNC(completion_time) rundate ,
COUNT( *) logswitch ,
ROUND((SUM(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)"
FROM v$archived_log
WHERE TRUNC(completion_time) > sysdate-31
GROUP BY TRUNC(completion_time)
ORDER BY 1;
Sample Output:
Code: Select all
RUNDATE LOGSWITCH REDO PER DAY (MB)
--------- ---------- -----------------
23-JAN-12 9 297
24-JAN-12 3 147
26-JAN-12 30 1074
27-JAN-12 3 147