某日全天的日志生成统计:
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)
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26478664/viewspace-711989/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26478664/viewspace-711989/