Finding Database Growth Mothly

Query to check database growth mothly:

SQL> select to_char(creation_time, 'MM-RRRR') "Month", sum(bytes)/1024/1024/1024 "Growth in GB"

from sys.v_$datafile

where to_char(creation_time,'RRRR')='2017'

group by to_char(creation_time, 'MM-RRRR')

order by  to_char(creation_time, 'MM-RRRR');

  2    3    4    5

Month   Growth in GB

------- ------------

01-2017            1

03-2017     .9765625

07-2017           12

1.Find the database used space from dba_segments

select sum(bytes/1024/1024/1024) from dba_segments;

find the database used plus free space from dba_data_files

select sum(bytes/1024/1024/1024) from dba_datafies;