Hi Lok,
As I see you are on 11.2.0.4 now. So first of all, I would suggest you to
upgrade to at least oracle 12.2, since intra-block row chaining doesn't
work for updates before 12.2:
http://orasql.org/2017/02/12/intra-block-row-chaining/
http://orasql.org/2017/06/17/intra-block-row-chaining-optimization-in-12-2/
http://orasql.org/wp-content/uploads/2017/04/Intra-block-row-chainingRuOUG.pdf
The last example in the presentation above shows how just 1 row has been
split into 101 blocks.
So any updates of null values in the end of rows you ran before split row
into another block.
--
Best regards,
Sayan Malakshinov
Oracle ACE Associate
Oracle DB Developer Choice Award winner
http://orasql.org
