My Oracle Support Banner

Recursive Branch Optimizer Changes from 18c (Doc ID 2749387.1)

Last updated on MARCH 30, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.