DBMS_UTILITY.FORMAT_CALL_STACK Is Slower in 11g When Compared to 10g in IBM AIX Platform.

(Doc ID 1450540.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version to [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, 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