--记录归档日志主要信息
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/