To print total and available space of Oracle database you can use next sql query. It’s a pretty good tool for monitoring.
select t1.tablespace_name, t1.fs/1024/1024/1024 as free_space_GB, t2.ts/1024/1024/1024 as total_space_GB from (select tablespace_name,sum(bytes) as fs from dba_free_space group by tablespace_name) t1 join (select TABLESPACE_NAME,sum(BYTES) ts from dba_data_files group by TABLESPACE_NAME) t2 on t2.TABLESPACE_NAME=t1.TABLESPACE_NAME ;
its should be look like this:
TABLESPACE_NAME FREE_SPACE_GB TOTAL_SPACE_GB --------------------------------------------- ------------- -------------- BASDAT 87.7402954 325.765625 BASIDX 96.0326538 294.882813 RPTADMINDAT .488220215 .48828125 RPTADMINIDX .488220215 .48828125 RPTBASDAT .488220215 .48828125 RPTBASIDX .488220215 .48828125 RPTCBFDAT .488220215 .48828125 RPTCBFIDX .488220215 .48828125 SYSAUX 2.82495117 5 SYSTEM 29.7844849 30.5859375 UNDOTBS1 21.7189941 107.324219 USERS 4.55554199 5.27929688
12 rows selected.
