Start with the OEM segment advisor:how can i find the tables that need to be reorganized?
After a reorg, adjust PCTFREE to avoid subsequent chaining, by allowing room in the block for the rows to expand.is there any other methods to avoid this problem.
You have row chaining when your specific "row" is bigger than your block size.If you increase PCTFREE, you might hit more chained rows.
Because your row is too big, your row is splitted and stored to multiple blocks.
Row chaining can't be solved by table recreation or move or reorganization whatever.
The only way is to redesign your physical schema not to make row that big.
You have row migration when your specific "row" got bigger by some updation
and there is no room for increased size. In this case Oracle migrate that row to
Row migration can be solved by delete/insert or move or table recreation whatever.
Also, it's deceptive. . . .Jonathan Lewis
Yes, it is straight-forward. Oracle has offered table reorg utilities for over a decade, and they are well-proven and reliable. Oracle now officially recommends tables (and indexes!) reorgs within the OEM segment advisor.It's not always as straight-forward as some people hope.