OBIA 11g Session SDE_PSFT_91_ADAPTOR_SDE_PSFT_GLACCOUNTDIMENSION Very Slow
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
- PeopleSoft 9.1.
- BI Apps 188.8.131.52.1
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?
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