DBMS_UTILITY.FORMAT_CALL_STACK Is Slower in 11g When Compared to 10g in IBM AIX Platform.
(Doc ID 1450540.1)
Last updated on MARCH 21, 2019
PL/SQL - Version 18.104.22.168 to 22.214.171.124 [Release 11.2] IBM AIX on POWER Systems (64-bit)
Application makes extensive use of the DBMS_UTILITY.FORMAT_CALL_STACK function and after upgrade to 11.2 from 10.2.0.5, performance has severely impacted (ie) it takes 40x more times to compile.
After receiving a patch for <bug 12740358> (which has been superseded by <bug 14019092>), the performance has improved a bit but the below tests still shows a degradation of 8 times over 10g.
This is specific IBM AIX platform.
Database base upgraded from lower version to 11.2.0.x.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!