Re: Query Transformation
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Mon, 25 Jan 2021 11:45:53 +0000
Message-ID: <CAGtsp8k2c3Qf3-z4X0dMyh9n4H=ps_7QAZBb4Y-jHjPMuLjBhA_at_mail.gmail.com>
Date: Mon, 25 Jan 2021 11:45:53 +0000
Message-ID: <CAGtsp8k2c3Qf3-z4X0dMyh9n4H=ps_7QAZBb4Y-jHjPMuLjBhA_at_mail.gmail.com>
"Doesn't work at all" might be a little bit of hyperbole, but I've just
done a quick search on MOS for "_optimizer_cbqt_or_expansion" and it
reported a significant number of documents and bugs which suggested it be
set to OFF.
Regards
On Mon, 25 Jan 2021 at 11:13, Moustafa Ahmed <moustafa_dba_at_hotmail.com>
wrote:
> I heard from someone in oracle real world performance team that
Jonathan Lewis
>
> _optimizer_cbqt_or_expansion
>
> Must be disabled at 19c
> As it has a bug and it does not work at all!
>
>
> On Jan 25, 2021, at 5:44 AM, Patrick Jolliffe <jolliffe_at_gmail.com> wrote:
>
> cost-based or-expansion
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 25 2021 - 12:45:53 CET