EGOICI: Import Catalog Items Performance Due To Business Rules, New Profile Available EGO: ITEM RULE PROCESS SIZE
Last updated on FEBRUARY 05, 2018
Applies to:Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
When doing performance testing, you were pumping the products varying from 15K to 20K per hour.
Consistently EGOICI took more than an hour to complete one single EGOICI.(For 20K, there will be 8 concurrent EGOICI would be triggered and running parallel). So, you took AWRs for the above ones and observed that the
business rules queries took consistently long time for all the EGOICI.
EGOICI is taking long time almost 2 times, when run with business rules enabled. When rules were disabled, EGOICI took 13 minutes and when the business rules were enabled, EGOICI took 33 minutes.
Sequence of events -
1. When pumped 20K products, 8 EGOICIs are triggered.
2. Each EGOICI took more than one hour to complete.
3. After analyzing AWRs for the above EGOICIs, business rules execution are consistently taking long time.
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