Performance: Concurrent Requests Hang in Pending Standby Status For Long Time
Last updated on NOVEMBER 22, 2017
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 .
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms