After Patching for Bug 28672124 Same SQL Has High CPU/Gets for Same # of Executions
(Doc ID 2767851.1)
Last updated on MAY 06, 2022
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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 ' kqrpe'. Applying a patch for <Bug 28672124> - PIPELINED FUNCTION CONSUMES MORE TIME IN 18C THEN 188.8.131.52 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.
Upgrade to 19c plus application of patch for <Bug 28672124> - PIPELINED FUNCTION CONSUMES MORE TIME IN 18C THEN 184.108.40.206. (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.)
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