Performance: Concurrent Requests Hang in Pending Status For Long Time

Performance: Concurrent Requests Hang in Pending Status For Long Time

Applies to:

Oracle Concurrent Processing - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Symptoms

Concurrent managers slow performance leaves many concurrent requests in the Pending/Normal status, extending the completion time due to the prolonged duration of the Pending/Normal state.

Changes

Fresh installation /upgrade to R12

Cause

The cause of this problem has been identified in Bug 9301929 , the relevant SQL code had not been tuned and the FND_CONCURRENT_REQUESTS_N2 index required more columns to improve its performance.
Solution

To implement the solution, please execute the following steps:

For 12.1.x

Apply Patch 12877707 . Update file afcmgr.odf to version 120.19.12010000.2 or higher.

Patch 12877707 modifies index FND_CONCURRENT_REQUESTS_N2 to include program_application_id  and  concurrent_program_id  following  existing  status_code. This improves the performance of the concurrent manager sub-system.

For 12.0.x

Apply Patch 10388925 . Update file afcmgr.odf to version 120.16.12000000.8 or higher.

@ FND_CONCURRENT_REQUESTS  FND_CONCURRENT_REQUESTS_U2 INDEX
@ create INDEX on column STATUS_CODE , PROGRAM_APPLICATION_ID ,
@ CONCURRENT_PROGRAM_ID hang in pending status long time