Re: cardinality feedback in 19c

Mohamed,

Have you spotted any common pattern to the 6 unlucky queries?

Regards
Jonathan Lewis

On Tue, 27 Apr 2021 at 13:53, Mohamed Houri <mohamed.houri_at_gmail.com> wrote:

> Hello Sayan
>
> Thanks for your answer. It confirms why I haven't experienced any performs
> pain with cardinality feedback in all the 19c databases I have to deal
> with. Until today where 6 critical queries changed their execution plan
> from a good one to a very bad one and the non-sharing reason was
> USE_FEEDBACK_STATS
>
> Best regards
> Mohamed
>
>

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