Ask a Question
Advertise on boostr.in
Question:What step can be taken to avoid row migration in the database?
a. ¬†¬†¬†¬†¬†¬†¬†Recreate the database with smaller DB_BLOCK_SIZE
b. ¬†¬†¬†¬†¬†¬†¬†Increase the PCTFREE setting on the tables with row migration problems
c. ¬†¬†¬†¬†¬†¬†¬†Increase the MAXEXTENTS setting on the tables with row migration problems
d. ¬†¬†¬†¬†¬†¬†¬†Increase the NEXT setting for the tables with row migration problems so that the size of the next extent allocated is bigger
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please