My Oracle Support Banner

EGOICI: Import Catalog Items Performance Due To Business Rules, New Profile Available EGO: ITEM RULE PROCESS SIZE (Doc ID 1919410.1)

Last updated on SEPTEMBER 11, 2019

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.