Oracle - ¿Cómo puedo saber el crecimiento de los tablespace en un determinado tiempo?

SELECT  df.tablespace_name "Tablespace",

   df.bytes / (1024 * 1024) "Size (MB)",

   SUM(fs.bytes) / (1024 * 1024) "Free (MB)",

   Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",

   Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"

FROM dba_free_space fs,

   (SELECT tablespace_name,SUM(bytes) bytes

      FROM dba_data_files

     GROUP BY tablespace_name) df

WHERE fs.tablespace_name (+)  = df.tablespace_name

GROUP BY df.tablespace_name,df.bytes

UNION ALL

SELECT df.tablespace_name tspace,

   fs.bytes / (1024 * 1024),

   SUM(df.bytes_free) / (1024 * 1024),

   Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),

   Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)

FROM dba_temp_files fs,

   (SELECT tablespace_name,bytes_free,bytes_used

      FROM v$temp_space_header

     GROUP BY tablespace_name,bytes_free,bytes_used) df

WHERE fs.tablespace_name (+)  = df.tablespace_name

GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used

ORDER BY 4 DESC;

select	name,

	to_char(creation_time, 'RRRR Month') "Mes",

	round(sum(bytes)/(1048576*1024)) "Crecimiento (Gb)"

from V$Datafile

group by name, to_char(creation_time, 'RRRR Month')

order by 1, 2;

Select T.NAME "Tablespace",

	to_char(D.CREATION_TIME, 'RRRR Month') "Mes",

	round(sum(D.BYTES)/1048576) CRECANYMB

From V$Datafile D, V$Tablespace T

Where	D.TS#=T.TS#

Group By T.NAME, to_char(D.CREATION_TIME, 'RRRR Month')

Order By 1, 2

select tsname,

    round(tablespace_size*t2.block_size/1024/1024/1024,2) "Tamaño Actual GB",

    round(tablespace_usedsize*t2.block_size/1024/1024/1024,2) "Espacio Usado GB",

    round((tablespace_size-tablespace_usedsize)*t2.block_size/1024/1024/1024,2) "Espacio Libre GB",

    round(val2*t2.block_size/1024/1024/1024,2) "Proy. Diario GB",

    round(val3*t2.block_size/1024/1024/1024,2) "Proy. Semanal GB",

    round(val4*t2.block_size/1024/1024/1024,2) "Proy. Mensual GB",

    round((tablespace_usedsize/tablespace_size)*100, 2) "% Usado",

    round((val2/tablespace_size)*100, 2) "% Proy. Diario",

    round((val3/tablespace_size)*100, 2) "% Proy. Semanal",

    round((val4/tablespace_size)*100, 2) "% Proy. Mensual"

from (select distinct tsname,

rtime,

tablespace_size,

tablespace_usedsize,

tablespace_usedsize-first_value(tablespace_usedsize)

over (partition by tablespace_id order by rtime rows 1 preceding) val1,

tablespace_usedsize-first_value(tablespace_usedsize)

over (partition by tablespace_id order by rtime rows 24 preceding) val2,

tablespace_usedsize-first_value(tablespace_usedsize)

over (partition by tablespace_id order by rtime rows 168 preceding) val3,

tablespace_usedsize-first_value(tablespace_usedsize)

over (partition by tablespace_id order by rtime rows 720 preceding) val4

from (select t1.tablespace_size, t1.snap_id, t1.rtime,t1.tablespace_id,

             t1.tablespace_usedsize-nvl(t3.space,0) tablespace_usedsize

     from dba_hist_tbspc_space_usage t1,

          dba_hist_tablespace_stat t2,

          (select ts_name,sum(space) space

           from recyclebin group by ts_name) t3

     where t1.tablespace_id = t2.ts#

      and  t1.snap_id = t2.snap_id

      and  t2.tsname = t3.ts_name (+)) t1,

dba_hist_tablespace_stat t2

where t1.tablespace_id = t2.ts#

and t1.snap_id = t2.snap_id) t1,

dba_tablespaces t2

where t1.tsname = t2.tablespace_name

and rtime = (select max(rtime) from dba_hist_tbspc_space_usage)

order by "Proy. Diario GB" desc,"Proy. Semanal GB" desc,"Proy. Mensual GB" desc

select dbid,SNAP_INTERVAL,RETENTION from dba_hist_wr_control;

Select *

from   V$VERSION