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;
