Multiple choice technology databases

Did row migration is caused by less pctfree space in datablock ?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Row migration occurs when a row grows too large to fit in its original data block due to insufficient PCTFREE space. PCTFREE reserves space in each block for future updates to existing rows. If set too low and rows expand, they must migrate to new blocks, leaving a forwarding pointer. This degrades performance due to additional I/O.

Keep practicing — related questions