某日全天的日志生成统计:
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)
/
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)
/