Script abaixo informa o tamanho das tablespaces:
SELECT df.tablespace_name "Tablespace"
,ROUND((SUM(NVL(fs.bytes,0))/ (df.bytes)) * 100) "%Free"
,ROUND(((df.bytes - SUM(NVL(fs.bytes,0)))
/ (df.bytes) ) * 100) "%Used"
,ROUND(SUM(NVL(fs.bytes/1024/1024,0))) "Mb Free"
,ROUND(df.bytes/1024/1024
- SUM(NVL(fs.bytes/1024/1024,0))) "Mb Used"
FROM dba_free_space fs, dba_data_files df
WHERE fs.file_id(+) = df.file_id
GROUP BY df.tablespace_name, df.file_id, df.bytes,
df.autoextensible
ORDER BY df.file_id;
