Script- Track redo generation by day

最新推荐文章于 2020-11-05 22:11:02 发布

leishifei

最新推荐文章于 2020-11-05 22:11:02 发布

阅读量297

点赞数

分类专栏： Oracle Scripts 文章标签： generation

本文链接：https://blog.csdn.net/leishifei/article/details/6432484

版权

Oracle Scripts 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

Script- Track redo generation by day

select trunc(completion_time) rundate
,count(*)  logswitch
,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)"
from v$archived_log
group by trunc(completion_time)
order by 1;

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

leishifei

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Script- Track redo generation by day

Script- Track redo generation by dayselect trunc(completion_time) rundate,count(*) logswitch,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)"from v$archived_loggroup by trunc(completion_time)order by 1;
复制链接

扫一扫