My Oracle Support Banner

Slow Performance with MerchUI Navigating from Site Catalogs to The List of Sites. (Doc ID 1487670.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Commerce Merchandising - Version 10.0 and later
Information in this document applies to any platform.


Navigating from Site Catalogs to the list of Sites is taking over a minute and a half.

Secured ProductCatalog is used.

Another area where the delay was found was with the following steps.

1. In Merchandising, search a category and open it.
2. Go to its 'Products' tab.
3. Click on 'Fixed child products' section
4. Hit 'Select' button
5. Pop up states loading --> This is very slow 5 minutes. No errors in the log.

The following SQL was taking a few minutes.




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.