oracle 統計redo統計當天日誌生成和最近日期日誌生成統計

某日全天的日誌生成統計：
select trunc(completion_time),sum(Mb)/1024 day_gb
from (select name,completion_time,blocks*block_size/1024/1024 Mb from v$archived_log where
completion_time between trunc(sysdate)-2 and trunc(sysdate)-1)
group by trunc(completion_time)
/
 
最近日期的日誌生成統計：
select trunc(completion_time),sum(Mb)/1024 day_gb
  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/14661773/viewspace-708499/，如需轉載，請註明出處，否則將追究法律責任。