DB GROWTH

Monthly:
----------
select to_char(creation_time, 'RRRR-MM'),sum(bytes)/1024/1024/1024 "Growth in GB"
from sys.v_$datafile
group by to_char(creation_time,'RRRR-MM')
order by to_char(creation_time, 'RRRR-MM');

Yearly:
--------
select to_char(creation_time, 'RRRR') "Yr",sum(bytes)/1024/1024/1024 "Growth in GB"
from sys.v_$datafile
group by to_char(creation_time,'RRRR')
order by to_char(creation_time, 'RRRR');

DB_SIZE:
==========

select (a.data_size+b.temp_size+c.redo_size)/1024/1024/1024 "DBSize GB"
from ( select nvl(sum(bytes),0) data_size
from dba_data_files ) a,
( select nvl(sum(bytes),0) temp_size
from dba_temp_files ) b,
( select nvl(sum(bytes),0) redo_size
from sys.v_$log ) c
/