Home  >  Oracle Database Administration (DBA)  >  Scripts  >  Find the Oracle database size

SELECT SUM (a.log_space + b.data_space + c.tempspace) "Total_DB_Size (G)"
          FROM (SELECT ROUND (SUM (BYTES/1024/1024/1024), 2) data_space
                            FROM dba_data_files) b,
                      (SELECT ROUND (SUM (BYTES*members/1024/1024/1024), 2) log_space
                            FROM v$log) a,
                      (SELECT NVL(ROUND(SUM(BYTES/1024/1024/1024),2), 0) tempspace
                            FROM dba_temp_files) c;