Calculate Database Size

Calculate total size of database and if you don't need size with TEMPFILE then you can make comment / remove the last line of script.

SELECT SUM (bytes) / 1024 / 1024 / 1024 GB
  FROM (SELECT SUM (bytes) bytes FROM v$datafile
        UNION
        SELECT SUM (BLOCK_SIZE) FROM v$controlfile
        UNION
        SELECT SUM (bytes * members) FROM v$log
        UNION
        SELECT SUM (bytes) FROM v$tempfile);

SELECT 'DATA_File: ' || SUM (bytes) / 1024 / 1024 / 1024 || ' GBytes'
          DATABASE_SIZE
  FROM dba_data_files
UNION
SELECT 'TEMP: ' || SUM (bytes) / 1024 / 1024 / 1024 || ' GBytes'
  FROM dba_temp_files
UNION
SELECT 'REDO LOGS: ' || SUM (bytes) / 1024 / 1024 / 1024 || ' GBytes'
  FROM v$log
UNION
SELECT    'CONTROLFILE: '
       || SUM (FILE_SIZE_BLKS * BLOCK_SIZE) / 1024 / 1024
       || ' MBytes'
  FROM v$controlfile;

Tags