统计归档日志

--记录归档日志主要信息
select name, completion_time, blocks * block_size / 1024 / 1024Mb
  from v$archived_log
 where rownum < 11
   and completion_time between trunc(sysdate) - 2 and trunc(sysdate) - 1
--某日全天的日志生成
  select trunc(completion_time), sum(Mb) DAY_MB
          from (select name,
                 completion_time,
                 blocks * block_size / 1024 / 1024 Mb
            from v$archived_log
           where completion_time between trunc(sysdate) - 11 and
                 trunc(sysdate) - 1)
         group by trunc(completion_time);

--最近日期的日志生成
select trunc(completion_time), sum(Mb) DAY_MB
  from (select name, completion_time, blocks * block_size / 1024 / 1024 mb
          from v$archived_log)
 group by trunc(completion_time)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22123669/viewspace-678443/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22123669/viewspace-678443/