Hi
I have this db growth script which i put together but i dont think its working well. Can somebody look at it or have a better 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')
;
IT ONLY SHOWS ME DATA thru 2002 Jan.
Month Growth in Meg
-------------- -------------
2001 August 20800
2001 December 4000
2001 July 800
2001 June 7700
2001 November 2000
2001 October 48000
2002 February 8000
2002 January 2000