oracle查询表变化量
·
根据变化量,可确定表的繁忙度,以及作为判断可能数据增长的对象。
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
更多推荐


所有评论(0)