Oracle统计指定时间内数据的增长量

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.spac

这个需求做不了

1449人浏览 · 2022-12-21 18:49:05

这个需求做不了 · 2022-12-21 18:49:05 发布

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