column owner format a10 column object_name format a30 column "tablespace name" format a15 select s.s_id ,s.e_id,o.owner , o.object_name , o.subobject_name , o.object_type , t.name "tablespace name", s.growth/(1024*1024) "growth in mb", (select sum(bytes)/(1024*1024) from dba_segments where segment_name=o.object_name ) "total size(mb)" from dba_objects o join (select min(ss.begin_interval_time) as s_id,max(ss.begin_interval_time) as e_id,ts#,obj#, sum(space_used_delta) growth from dba_hist_seg_stat st join dba_hist_snapshot ss on st.snap_id=ss.snap_id group by ts#,obj# having sum(space_used_delta) > 0 order by 2 desc ) s on s.obj#=o.object_id join v$tablespace t on s.ts#=t.ts# where rownum < 11 order by 8 desc;
found at community.oracle.com