How to find out database growth in a year.

Script:

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 to_char(creation_time, 'RRRR Month');

Output:

Month       Meg

-------------- ----------

2012 November 143.8125

2012 October       100

2013 March     1024