Originally posted by ser
hi

the manuals say if the extent sizes of the tablespace are all uniform , there is no need to coalesce.

but even if the allocation type is uniform , still there must be some free space which could be left in a tablespace which can be considered for coalesing . if i am not wrong one could require coalescing for uniform managed tablespaces.

thanks
I dont think Coalace will do any help for LMT & Uniform Extents.