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