freespace2.sql

select substr(c.name,1,20) tablespace, round(sum((a.length) * 8192)/1000000,1)
free_space,count(*) fragments,round(max((a.length)*8192)/1000000,1) largest
from sys.fet$ a, sys.ts$ c
where c.ts#=a.ts#
group by substr(c.name,1,20)
order by substr(c.name,1,20)
/