Query To Check Oracle Database Size

Download(dbsize.sql)

REM +======================================================================+
REM                    
REM File Name: dbsize.sql
REM 
REM Description:
REM   Query To Check Oracle Database Size
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @dbsize.sql
REM   
REM +======================================================================+

clear columns
set lines 180
SELECT "DATABASE_SIZE(GB)", "DATABASE_SIZE(GB)" - "FREE_SPACE(GB)" "USED_SPACE(GB)", "FREE_SPACE(GB)"
  FROM (SELECT (SELECT SUM (BYTES / (1014 * 1024 * 1024))
                  FROM dba_data_files) "DATABASE_SIZE(GB)", (SELECT SUM (BYTES / (1024 * 1024 * 1024))
                                                               FROM dba_free_space) "FREE_SPACE(GB)"
          FROM DUAL);