OBIA 11g Session SDE_PSFT_91_ADAPTOR_SDE_PSFT_GLACCOUNTDIMENSION Very Slow (Doc ID 1958970.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

During our load plan execution, the session "SDE_PSFT_91_ADAPTOR_SDE_PSFT_GLACCOUNTDIMENSION" is running very slow.

Within the session there are 24 lookups to the same source table (SET_CNTRL_REC) resulting in the same dataset each time.
Each lookup takes about 5 minutes in our DEV environment (representing just a small subset of the PROD data), so just the lookups take over 2 hours to complete

Is there a way to improve this interface, so we can use the lookup just once and reuse it from the cache?

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