【转】查看oracle每天及每小时产生归档日志的数据量

-- 查看每天产生归档日志的数据量
来源：http://blog.51cto.com/bjiokn/321878

alter session set nls_date_format='yyyy.mm.dd hh24:mi:ss';
select trunc(completion_time) as ARC_DATE,
       count(*) as COUNT,
       round((sum(blocks * block_size) / 1024 / 1024), 2) as ARC_MB
  from v$archived_log
 group by trunc(completion_time)
 order by trunc(completion_time);

-- 查看最近几天，每小时归档日志产生数量
来源：https://blog.csdn.net/u010692693/article/details/75309167

SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) Day,
       SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'00',1,0)) H00,
       SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'01