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;