Coalesce될 수 있는 tablespace조회

   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;