-
Coalesce tablesapce
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|