select u.tablespace_name, u.used_kb, f.free_kb, u.used_kb + f.free_kb size_kb, round((u.used_kb * 100) /(u.used_kb + f.free_kb), 1) perc from ( select tablespace_name, sum(bytes) / 1024 used_kb from dba_segments group by tablespace_name ) u, ( select tablespace_name, sum(bytes) / 1024 free_kb from dba_free_space group by tablespace_name ) f where u.tablespace_name = f.tablespace_name and round((u.used_kb * 100) /(u.used_kb + f.free_kb), 1) > #P1#