My Oracle Support Banner

Slow Performance on Mapping Rule - High Disk Reads Using Large FEM_BALANCES_P Index (Doc ID 760300.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Profitability Manager - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Mapping Rules
FEMCCE

Symptoms

In Profitability Manager 11i, a Mapping Rule that processes against the FEM_BALANCES table is running very slowly.  The initial data source of the rule includes a hierarchy dimension component, an attribute dimension component or both.

After performing a SQL trace, you can see a SQL statement similar to the following is slow:


Looking at the Explain Plan, the optimizer is using the FEM_BALANCES_P index to query the FEM_BALANCES table for values.  The FEM_BALANCES_P index is very large and contains almost all dimension columns on the FEM_BALANCES table.  Several dimension columns used in the "where" clause of the SQL are located in the middle or end of the index.

Additionally:

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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