My Oracle Support Banner

SQL Plans Changed To Worse After Patch 19.22.0.0.240116 Was Installed (Doc ID 3064262.1)

Last updated on JANUARY 06, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Symptoms

Customer have installed Patch 19.22.0.0.240116 (on 19.15) and some SQLs produce wrong plans

SQL performs abnormally slow when using to_date function inside a custom defined function. However when the SQL is executed with just to_date function it executes with good performance.

Changes

 

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.