Database Growth Month Wise

Post date: 27-Nov-2012 23:35:18

COLUMN month FORMAT a75

COLUMN growth FORMAT 999,999,999,999,999

SELECT

TO_CHAR(creation_time, 'RRRR-MM') "Month",

SUM(bytes/1024/1024) "growth in MB"

FROM sys.v_$datafile

GROUP BY TO_CHAR(creation_time, 'RRRR-MM')

ORDER BY TO_CHAR(creation_time, 'RRRR-MM');