set feedback off
set echo off
set feedback off
set heading off
set pagesize 10000

column TABLESPACE_NAME format a16
column "object name" format a30
column object_type format a11

spool /home/oracle/scripts/Daily_Table_Report.out

ttitle "Growth by Object"

select * from (select c.TABLESPACE_NAME,c.segment_name "Object 
Name",b.object_type, sum(space_used_delta) / 1024 / 1024 "Growth (MB)"
from dba_hist_snapshot sn,
dba_hist_seg_stat a,
dba_objects b,
dba_segments c
where begin_interval_time > trunc(sysdate) - 1 and sn.snap_id = 
a.snap_id and b.object_id = a.obj# and b.owner = c.owner and 
b.object_name = c.segment_name and c.owner = 'BLADELOGIC'
group by c.TABLESPACE_NAME,c.segment_name,b.object_type)
order by 3 desc, 4 desc;

ttitle "Growth by Tablespace"

select * from (select c.TABLESPACE_NAME, sum(space_used_delta) / 1024 / 1024 "Growth (MB)"
from dba_hist_snapshot sn,
dba_hist_seg_stat a,
dba_objects b,
dba_segments c
where begin_interval_time > trunc(sysdate) - 1 and sn.snap_id =
a.snap_id and b.object_id = a.obj# and b.owner = c.owner and
b.object_name = c.segment_name and c.owner = 'BLADELOGIC'
group by c.TABLESPACE_NAME);
spool off;

exit;