List all tablespaces size
SELECT /* + RULE */ df.tablespace_name “Tablespace”, df.bytes / (1024 * 1024) “Size (MB)”, from dba_data_files ) a, ( select nvl(sum(bytes/1024/1024/1024),0) temp_size SUM(fs.bytes) / (1024 * 1024) “Free (MB)”, Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) “% Free”, Round((df.bytes – SUM(fs.bytes)) * 100 / df.bytes) “% Used” FROM dba_free_space fs, (SELECT tablespace_name,SUM(bytes) bytes …
