To Identify Space occupied and original space utilized of a database

set numf 999999.99
select sum(bytes)/(1024*1024*1024) “Total Allocated GB”,Total_Consumed_GB from dba_data_files,
(select sum(bytes)/(1024*1024*1024) Total_Consumed_GB from dba_segments) group by Total_Consumed_GB;