HOW TO QUERY DATABASE SIZE

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

If you're looking for the total size of all of the datafiles (i.e., how much disk space is occupied by the database's datafiles):

select sum(bytes) from dba_data_files;

If you're looking for the total space used by all of the segments in the database (i.e., how much data is in the database):

select sum(bytes) from dba_segments;