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) /