Sayan,
I'd forgotten that little gem in the pdf you listed. It reminded me of the
little quiz I posted:
https://jonathanlewis.wordpress.com/2012/03/30/quiz-night-17
I've just been following up the MOS reference in the comments - with the
increasingly common result that I've found bug notes and SRs disappearing,
or articles that were relevant 20 years ago being labelled with a very
recent "last major update" date, but containing no new information since 9i.
Wondering if there were any fixes backported from the 12.2 to 11.2.0.4 -
there are people running SE that probably won't ever want to upgrade to 12c
because of the new restrictions in SE2, but could run into trouble with 11g
bugs.
Regards
Jonathan Lewis
On Thu, 19 Nov 2020 at 00:40, Sayan Malakshinov <xt.and.r@xxxxxxxxx> wrote:
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
