OBIA 7x : How To Reduce The Duration Of the ETL Run for the task SIL_MfgMaterialUsageFact which is taking more time to create indexes
Last updated on AUGUST 11, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124 to 126.96.36.199 [Release V7]
Information in this document applies to any platform.
On Oracle Business Intelligence Applications (OBIA) 188.8.131.52
The Source is EBS 12.1.3
Source DB: Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production.
Target DB: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production.
Dac Build AN 18.104.22.168.4.20121119.2022;
The task SIL_MfgMaterialUsageFact takes about 3 hours to run. Most of time is used in creating indexes.
DAC log shows creating the BITMAP indexes taking more time for W_MFG_MATERIAL_USAGE_F table.
How to improve the performance of this task ?
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