Re: Table with ~255+ columns

Thank you. Yes we have plans to move to 19C in 2021, but I think we are not seeing the impact because we have very minimal to No update on this table. so perhaps that's why , even though we are on 11.2.0.4 , we are still surviving :).

On Thu, Nov 19, 2020 at 6:10 AM Sayan Malakshinov <xt.and.r_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l