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 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

To view full details, 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 a vibrant support community of peers and Oracle experts.