rem ----------------------------------------------------------------------
-
rem Filename:  dbgrowth.sql
rem Purpose:    Show database growth in Meg per month for the last year
rem DB Version: 8.0 or above
rem Date:      19-Mar-2000
rem Author:    Frank Naude, Oracle FAQ
rem ----------------------------------------------------------------------
-

set pagesize 50000
tti "Database growth per month for last year"

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')
/

tti off


select count(bytes),sum(bytes)/1024/1024 from sys.v_$datafile;