select obj.owner, obj.object_name,obj.OBJECT_TYPE,a.TS#,
to_char(sn.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD hh24:mi:ss') BEGIN_TIME,
to_char(sn.END_INTERVAL_TIME, 'YYYY-MM-DD hh24:mi:ss') END_TIME,
round(a.space_used_delta / 1024 / 1024 / 1024, 2) DELTA_USED_SIZE_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.owner not in ('SYS','SYSTEM')
and end_interval_time between to_timestamp('开始时间','YYYY-MM-DD') and to_timestamp('结束时间','YYYY-MM-DD')
and owner = '用户名'
order by DELTA_USED_SIZE_GB desc,obj.owner, obj.object_name
Oracle统计指定时间内数据的增长量
最新推荐文章于 2024-07-12 07:13:33 发布