DBMS_UTILITY.FORMAT_CALL_STACK Is Slower in 11g When Compared to 10g in IBM AIX Platform.
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version 188.8.131.52 to 184.108.40.206 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms