Performance Problem While Loading Products (Doc ID 1618237.1)

Last updated on MARCH 08, 2019

Applies to:

Goal

While loading products with huge hierarchy through iHub, user facing performance problem.

There are products with huge count of children products. There are about 8000 products with the same parent product. And loading all of them into OMIPM with iHub. If one big XML is created with all this

hierarchy, Then, There would be very huge file which cannot be loaded, because iHub is working with this file during 15 minutes and then fall with timeout error. So, User decided to divide this huge XML

file with 8000 children products into several files with 100 children products each. Then loading of these files started one by one and observed performance problem.

top activity page from Oracle Enterprise Manager. In this case, we can see about 50% of time "Row Lock Contention" wait event, which is not good .


Also,

There is another problem with products loading. There are 3 products with huge hierarchy which are cannot be loaded.

For example, product with prod_id_user = 204744, already have 7470 loaded children, and 3985 children which are not yet loaded. We send XML with 50

children to iHub, and after a while we got an error in ihub_ack_status.

 Following is the error:

Solution

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