Retour
-
Titre
Proper Rollback Sizing for Live Reorg -
Description
Live-Reorg
If the rollback segments are not properly sized, then the live reorg will not succeed. -
Résolution
To determine how large rollback segments should be for a Live reorganization, estimate how long it will take to copy the largest table and recreate the index on the table. Next, estimate how much redo will be generated in that length of time and divide by 2. EACH rollback segment should be AT LEAST this large. Also, each rollback should be sized so it is not allowed to shrink below this minimum.