My Oracle Support Banner

Pipelined Function Consumes More Time IN 18C Than 12.2.0.1 (Doc ID 2603568.1)

Last updated on MARCH 04, 2022

Applies to:

PL/SQL - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Pipelined function in 18.3 which returns a record of many elements consumes more time than 12.2.

Adding more elements to the select increases time consumption further.

It can be explained with the help of below example

Changes

 Upgraded to 18.3

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.