1.查看每周生成的归档量

select logtime, count(*), round(sum(blocks * block_size) / 1024 / 1024) mbsize from (select trunc(first_time, ‘dd‘) as logtime, a.BLOCKS, a.BLOCK_SIZE from v$archived_log a where a.DEST_ID = 1 and a.FIRST_TIME > trunc(sysdate - 7)) group by logtime order by logtime desc;LOGTIME COUNT(*) MBSIZE--------- ---------- ----------05-NOV-18 225 1146504-NOV-18 516 2621103-NOV-18 510 2594602-NOV-18 508 2560601-NOV-18 497 2533031-OCT-18 495 2509530-OCT-18 488 2478129-OCT-18 483 24568