OSM Web UI Order Details Fetch Is Sometimes Slow (Doc ID 1969543.1)

Last updated on MARCH 28, 2023

Applies to:

Symptoms

A User is reporting slow performance,  OSM Web UI Order Details fetch is sometimes slow
OSM Web UI Order Details fetch is sometimes slow
Order Details fetch is sometimes slowOrder Details fetch is sometimes slowOrder Details fetch is sometimes slow
when using the webUI order fetch.

Use case; If a user is debugging an order, the user goes to OSM web UI (reachable on the following url http://serverIP:port/OrderManagement/orchestration). The user uses the search fields to find OSM orders and access their respective data, and orchestration plans … The access to this information is done by going to the order details of any of the search results.

Accessing the Order details is taking too much time, depending on the environment and type of orders (order size, cartridge …).

From the AWR report, snippet from the problematic SQL statement;

Cause

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