Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fragmentation: Table Increase after ALTER TABLE MOVE

User_D2LZAJun 2 2021

Hi, I wonder if anyone can help with a fragmentation issue.
Version = 11.1.0.7
I have carried out an ALTER TABLE MOVE and the table has increased by 15% and fragmentation has increased from 23% to 35%.
PCT free is the same (30) as is the table DDL.
Extents are larger and fewer on the new table i.e. 1583 extents in new table vs 3618 extents in old table, so I would expect this to result in LESS fragmentation.
Can anyone suggest why the table might have increase of suggest where I should go next in the investigation?
I have not found anything e.g. bug on oracle support.

Thanks

This post has been answered by Solomon Yakobson on Jun 2 2021

Jump to Answer

Added on Jun 2 2021

#general-database-discussions

11 comments

2,006 views

1 mention