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 11.2.0.1 to 11.2.0.3 [Release 11.2]
IBM AIX on POWER Systems (64-bit)

Symptoms

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.  

 

Changes

Database base upgraded from lower version to 11.2.0.x.

Cause

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