My Oracle Support Banner

Pipelined Function Consumes More Time In 18C Then 12.2.0.1 (Doc ID 2544001.1)

Last updated on APRIL 17, 2023

Applies to:

PL/SQL - Version 12.2.0.1 and later
Generic (Platform Independent)

Symptoms

In 18C ,A fetch from RDBMS to local pl/sql collections exhibiting performance regression from earlier releases (12.2.0.1).

Elapsed: 00:01:23.69 - 18C

Elapsed: 00:00:16.24 - 12C

18C most of the time is consumed by

Changes

Upgraded to 18C.

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.