If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory or disk group specified by the db_recovery_file_dest parameter.
You can use the following query to check how much archive log is generated daily. The query result will give the total generated archive log size in mb per day.
Query To Check Archive Log Size Generated per day
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
SQL> select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1; TIME SIZE_MB --------- ---------- 12-DEC-18 26.8168945 13-DEC-18 906.962891 15-DEC-18 49136.6299 16-DEC-18 950.592285 17-DEC-18 2730.39063 20-DEC-18 2881.69336 22-DEC-18 865.368164 23-DEC-18 862.506836 24-DEC-18 947.997559 26-DEC-18 912.13916 27-DEC-18 516.206055 28-DEC-18 864.518555 29-DEC-18 866.547363 30-DEC-18 859.300293 31-DEC-18 862.097656 02-JAN-19 861.827637 04-JAN-19 864.342773 05-JAN-19 863.86084 06-JAN-19 858.840332 08-JAN-19 860.28125 10-JAN-19 869.404297 12-JAN-19 863.470703 13-JAN-19 865.046387 23 rows selected. |
