col c1 heading
“Tablespace|Nnumber”
col c2 heading “Tablespace|Name”
col c3 heading
“Coalescable|Extents”
select c.ts# c1,c.name c2,count(*) c3
from sys.fet$ a,sys.fet$ b,sys.ts$ c
where a.ts# = b.ts#
and a.ts# = c.ts#
and a.file# = b.file#
and (a.block# + a.length) = b.block#
group by c.ts#,c.name;