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@xxxxxxxxx> 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