Re: [EXTERNAL] Question on sql plan management

Sometimes that happens because the plan should never have been allowed in the first place - often because someone has worked out a boundary condition where a transformation would produce the wrong results if some column were allowed to be null. So a transformation is blocked (sometimes for a few versions only) until the code is refined to avoid the error.

Regards
Jonathan Lewis

On Thu, 1 Sept 2022 at 12:33, Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> wrote:

> We are upgrading an Oracle EBS database from 11.2.0.4 to 19c. During final
> testing, we noticed some Payroll processes running longer than anticipated.
> We created a baseline in 11g and migrated it to 19c. The 19c database did
> NOT use the baseline. From what I read, this can happen if the optimizer
> can not reproduce the plan in the baseline. Just passing this on for what
> its worth.
>
>
>

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