My Oracle Support Banner

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

Last updated on AUGUST 17, 2022

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 ***


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:




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.