My Oracle Support Banner

After Patching for Bug 28672124 Same SQL Has High CPU/Gets for Same # of Executions (Doc ID 2767851.1)

Last updated on APRIL 30, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 12.2 to 19c, queries ran two times slower in 19c than they had in 12.2   A query of awr_pdb_latch showed high waits for 'kokc descriptor allocation latch,' and a query of the mutex sleep history reported mostly mutex_type 'Row Cache' for location '[19] kqrpe'.  Applying a patch for <Bug 28672124> - PIPELINED FUNCTION CONSUMES MORE TIME IN 18C THEN 12.2.0.1 resolved the performance issue, but more than doubled the number of buffer gets (and thus CPU) for the same number of executions.

Bug 28672124 - PIPELINED FUNCTION CONSUMES MORE TIME IN 18C THEN 12.2.

Changes

 Upgrade to 19c plus application of patch for <Bug 28672124> - PIPELINED FUNCTION CONSUMES MORE TIME IN 18C THEN 12.2.0.1.  (See <Document 28672124.8> Bug 28672124 - Performance Issue From PLSQL Unit While Fetching Object Type To Collection Type for more information about this bug and the versions if affects.)

 

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.