Recursive Branch Optimizer Changes from 18c
(Doc ID 2749387.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Some statements may not complete on 18c when they were working with adequate response in 12c. If the Statement uses Common Table Expression and performs adequately in 12c but not 19c then this may be the problem you are encountering. The execution plan will be different in 19c and cost may also be much higher.
Additionally, if the initialization parameter in 18c for (ALTER SYSTEM SET optimizer_features_enable='12.1.0.2' SCOPE=BOTH; --originally 18.1.0) is set the execution plan may change back to an acceptable one.
Changes
An upgrade or change in the Optimizer environment.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |