Last updated on MARCH 09, 2017
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
Million Knowledge Articles and hundreds of Community platforms