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)
/
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博客 ” ，链接：https://blog.itpub.net/29376842/viewspace-1536495/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
