Performance: Concurrent Requests Hang in Pending Standby Status For Long Time
(Doc ID 1541526.1)
Last updated on APRIL 25, 2023
Applies to:Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Concurrent Requests stay in Pending Standby for longer time. Conflict Resolution Manager (CRM) is processing the requests slower and huge number of incompatible concurrent requests pending in the Queue.
- The requests hang in Pending Standby for longer time.
- The requests may be completed by the respective concurrent manager faster. But requests take longer time (around 30 seconds) before they get picked by the respective concurrent manager.
- This could be visible only when the count of incompatible Pending Requests are very high ( For example 50,000 ) at CRM .
- The below DMLs are found in AWR report with high elapsed time. These DMLS are executed by CRM internally causing the slowness.
Bulk submission of Concurrent Requests. The count of incompatible Pending Requests are very high ( For example 50,000 ) at CRM .
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