Performance Issues on SLA Tables for 11.2.0.3 Database (Doc ID 1465689.1)

Last updated on DECEMBER 24, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Assets - Version 12.1.3 and later
Oracle Cost Management - Version 12.1.3 and later
Oracle Subledger Accounting - Version 12.1.1 and later
Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 For customers who have RDBMS Version 11.2.0.3, there are certain performance issues for queries involving the SLA (XLA Schema) tables below due to incorrect statistics at the index partition level:

Any modules that use SLA or SLA tables may be impacted by this issue.

 

Changes

 The issue is mostly seen for customers who have RDBMS version 11.2.0.3.

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