How to see table growth in Oracle

SELECT obj.owner, obj.object_name,
           to_char(sn.BEGIN_INTERVAL_TIME,'DD-MON-RR') start_day,
           ROUND(sum(a.db_block_changes_delta)/***8/1024/1024,2***/) gb_increase
  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        obj.object_name='&TABLE'
  and      end_interval_time between to_timestamp('4-FEB-23','DD-MON-RR')
           and to_timestamp('13-FEB-23','DD-MON-RR')
  group by obj.owner, obj.object_name,
           to_char(sn.BEGIN_INTERVAL_TIME,'DD-MON-RR')
  order by obj.owner, obj.object_name

Leave a Reply

Your email address will not be published. Required fields are marked *