Performance Problem While Loading Products
Last updated on JUNE 12, 2017
Applies to:Oracle Media Intellectual Property Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
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 .
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:
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