OBIA 11.1.1.8.1 Performance issue on SDE_ORA_STAGE_GLHIERARCHY_SEGMENTRANGE_DERIVE.W_ORA_GL_HIER_RGE_DERV_DH_TMP (Doc ID 1960958.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

After installing OBIA 11.1.1.8.1 and completing the Setup and Functional configuration following oracle documentation, the initial load of Financial Analytics started.

However, there are performance issues on the task W_ORA_GL_HIER_RGE_DERV_DH_TMP in the SDE_ORA_STAGE_GLHIERARCHY_SEGMENTRANGE_DERIVE mapping. The process was running for more than 6 Hours. During troubleshooting, the solution in the following note was applied:

<Note 1684142.1>  BIA 11g ODI-1228: Unable To Complete FULL Load In OBIEE 11.1.1.7.0

But the performance problem persists.


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