Re: Question on 19C Optimizer
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 24 Jul 2021 13:12:51 -0400
Message-ID: <85eedff6-3ad1-4047-cff8-618e2f4a32a9_at_gmail.com>
Date: Sat, 24 Jul 2021 13:12:51 -0400
Message-ID: <85eedff6-3ad1-4047-cff8-618e2f4a32a9_at_gmail.com>
When migrating, why not migrate to the latest release? And that
is 19.12. Yes, object-relational mappers can produce ghastly
queries. And if you need to add hints, you can always create a
baseline or use DBMS_SQLDIAG.CREATE_SQLPATCH.
On 7/24/21 7:28 AM, Lok P wrote:
This bug looks too generic and so we are a bit worried as we just can't go adding leading hints for all queries. But then considering so many application runs on the below 19.9 versions, wanted to know from experts here if this occurs only on certain situation? Or we really have to have patch for this before migrating to 19C?
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- http://www.freelists.org/webpage/oracle-l Received on Sat Jul 24 2021 - 19:12:51 CEST