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

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.

Symptoms

BACKGROUND
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.

Changes

 

Cause

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