sqlplus / as sysdba
>select total.tablespace_name,round(total.MB,2) as Total_MB,round(total.MB-free.MB, 2) as Used_MB,round((1-free.MB/total.MB)*100, 2) as Used_Pct from (select tablespace_name, sum(bytes)/1024/1024 as MB from dba_free_space group by tablespace_name) free,(select tablespace_name, sum(bytes)/1024/1024 as MB from dba_data_files group by tablespace_name) total where free.tablespace_name=total.tablespace_name;
TABLESPACE TOTAL_MB USED_MB USED_PCT
---------- ---------- ---------- ----------
UNDOTBS1 805 33.31 4.14
SYSAUX 340 331.56 97.52
BLOBS 1000 194.38 19.44
USERS 6984 6916.31 99.03
SYSTEM 360 355.25 98.68
INDX 1500 428.44 28.56
WCAUDIT 500 .06 .01