OBIA 18.104.22.168.1 Performance issue on SDE_ORA_STAGE_GLHIERARCHY_SEGMENTRANGE_DERIVE.W_ORA_GL_HIER_RGE_DERV_DH_TMP
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
After installing OBIA 126.96.36.199.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:
But the performance problem persists.
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