根据变化量,可确定表的繁忙度,以及作为判断可能数据增长的对象。

select obj.owner, obj.object_name, 
to_char(sn.BEGIN_INTERVAL_TIME,'yyyy-mm-dd') start_day, 
round(sum(a.db_block_changes_delta*8)/1024/1024,2) incr_GB 
from dba_hist_seg_stat a, 
dba_hist_snapshot sn, 
dba_objects obj 
where sn.snap_id = a.snap_id 
and obj.object_id = a.obj# 
and obj.object_type='TABLE'
and obj.owner not in ('SYS','SYSTEM') 
and end_interval_time between to_timestamp('2020-05-11','yyyy-mm-dd') and to_timestamp('2020-05-12','yyyy-mm-dd') 
group by obj.owner, obj.object_name, 
to_char(sn.BEGIN_INTERVAL_TIME,'yyyy-mm-dd') 
order by obj.owner, incr_GB desc

 

更多推荐