Get Oracle Database Growth up by Month

Get Oracle Database Growth up by Month

SELECT To_char(creation_time, 'RRRR') year,
To_char(creation_time, 'MM') month,
Round(SUM(bytes) / 1024 / 1024 ) MB 
FROM v$datafile
GROUP BY To_char(creation_time, 'RRRR'),
To_char(creation_time, 'MM')
ORDER BY 1, 2;