My Oracle Support Banner

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

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.