My Oracle Support Banner

Slow Performance When Attempting to Complete PSR Order Due Date Tasks (Doc ID 872214.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.
*** Reviewed for relevance on 23-JAN-2019 ***

Symptoms

Slow performance encountered when attempting to complete Due Date tasks.  Users will report that the Due Date task they're attempting to complete hangs or hourglasses for a long period of time.  The DBA may report the poor performing query appearing in the WORKLOAD REPOSITORY report as needing to be optimized by the application vendor. 

The following SQL can help identify the problem by showing the process that is consuming the highest amount of CPU resources on the database:

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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