Query With Pipelined Function Response Is Slow After Database Patching From 19.17 to 19.19
(Doc ID 2966931.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.19.0.0.0 and later
Information in this document applies to any platform.
Symptoms
- Query with Pipelined function response is slow after patching with 19.19 DBRU than 19.17.
- High buffer gets observed.
- After pinning the good plan for the original query with sql profile, the response is still slow.
- In 19.17, it take milliseconds to complete and in 19.19, it takes ~30 sec to complete.
Changes
Database upgraded from 19.17 to 19.19
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.