My Oracle Support Banner

Performance Issue With SDE_FUSION_SLASUPPORTINGREFERENCEDIMENSION Mapping (Doc ID 2736224.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

ETL on SDE_FUSION_SLASUPPORTINGREFERENCEDIMENSION mapping is having Performance issue, ETL takes more than 7 hours to complete whereas usually it would complete by 5 hours.

Environment details:
1. OBIA Version: 11.1.1.10.2
2. Modules: CRM HCM OTBI, Financial Analytics.
3. Source: Oracle Fusion R12. .
4. ODI Version - 11.1.1.9.0
5- Full load

Changes

Have done index rebuilding and suspected on parallelism, There are parallel sessions are getting created when one session executes.

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.