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 [Release 11.5]
Oracle Profitability Manager - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.
Mapping Rules


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.





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.