Hi,

Is there any way to make multiple single free extent to a big extent. One of our tablespace has 162 free extents with different sizes (1MB, 5 MB etc..), totally it is around 1G with maximum extent 10 MB.

Any one of the free extent is not being used, because all the segments belogs to that tablespace has 30+ MB as next extent.

It was not done when I coalesced the tablespace, it seems all free extents are not near to each other.



Thanks,