Oracle Database growth per month

col Month format a30
select to_char(creation_time, 'RRRR Month') "Month",sum(bytes)/1024/1024 "Growth in Meg" from sys.v_$datafile
where creation_time > SYSDATE-365
group by creation_time



col year format a20
select to_char(CREATION_TIME,'RRRR') year, to_char(CREATION_TIME,'MM') month, round(sum(bytes)/1024/1024/1024) GB
from v$datafile
group by to_char(CREATION_TIME,'RRRR'), to_char(CREATION_TIME,'MM')
order by 1, 2;


YEAR MONTH GB
-------------------- ------------------------------ ----------
2005 02 6
2005 04 21
2006 04 1
2006 09 2
2007 01 8
2007 03 2
2007 07 2
2008 01 2
2008 06 2
2008 10 2
2009 07 0
2009 12 2
2010 09 2
2010 12 2
2011 05 2
2011 08 2
2011 10 2