Oracle Database size

To Find an oracle database size 

SELECT SUM (bytes) / 1024 / 1024 / 1024 AS GB FROM dba_data_files;

The above dba_data_files view will calculate size of the (actual) all datafiles created with the 

current size.