7 Oracle Concurrent Processing

An Oracle concurrent manager is a process manager that coordinates the processes generated by users' requests to run various data-intensive programs. An Oracle E-Business Suite product group can have several concurrent managers.

For more information about Oracle concurrent processing, see your Oracle E-Business Suite documentation.

7.1 Active Concurrent Requests by Application

This metric category collects information about active concurrent requests by application.

Data Source

This metric is computed by counting the total active concurrent requests by application from the FND_CONCURRENT_REQUESTS table.

7.1.1 Application Name

This metric displays the name of the application.

Target Version Collection Frequency
All Versions Every 15 Minutes

7.1.2 Application Short Name

This metric displays the short name of the application.

Target Version Collection Frequency
All Versions Every 15 Minutes

7.1.3 Non-Repeating Pending requests (Normal and Standby)

This metric displays the number of nonrepeating pending requests (both normal and standby status).

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined Number of Non Repeating Pending Requests for application %application_name% is %value%

User Action

If there are an unusually high number of pending requests, then check if all the concurrent managers are active.

7.1.4 Non-Repeating Running requests

This metric displays the number of nonrepeating running requests.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined Number of Non Repeating Running Requests for application %application_name% is %value%

7.1.5 Repeating Pending requests (Normal and Standby)

This metric displays the number of repeating pending requests (both normal and standby status).

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined Number of Repeating Pending Requests for application %application_name% is %value%

User Action

If there are an unusually high number of pending requests, then check if all the concurrent managers are active.

7.1.6 Repeating Running requests

This metric displays the number of repeating running requests.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined Number of Repeating Running Requests for application %application_name% is %value%

7.2 Activity

This metric category provides information about active concurrent requests.

Data Source

These metrics are computed by counting the total active concurrent requests by application from the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES and FND_LOGIN_RESP_FORMS tables.

7.2.1 Active Service Processes

This metric displays the number of active service processes.

Target Version Collection Frequency
All Versions Every 15 Minutes

7.2.2 Concurrent Requests Running

This metric displays the number of concurrent requests running.

Target Version Collection Frequency
All Versions Every 15 Minutes

7.3 Capacity Utilization of Concurrent Managers

This metric category compares the number of instances of concurrent managers running to that of the maximum number allowed and gets the capacity as a percentage of maximum number allowed. This is calculated for all types of concurrent managers such as Concurrent Manager, Internal Concurrent Manager and so on. You can set an alert if the capacity utilization of concurrent managers drops below a specific threshold.

Data Source

The number of instances per manager and the maximum instances allowed per manager is obtained from FND_CONCURRENT_QUEUES and the percentage is calculated.

7.3.1 Manager Name

This metric displays the name of the concurrent manager.

Target Version Collection Frequency
All Versions Every 1 Day

7.3.2 Utilized Capacity

This metric displays the utilized capacity for all the concurrent managers.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined Utilized Capacity of manager %manager_name%: %value%%

7.4 Concurrent Requests in Blocked State

This metric category provides information about concurrent requests that are in blocked state (such as row locks).

You can set an alert to inform you if a request is in blocked state for more than a specific threshold.

7.4.1 Blocking Action

This metric displays the blocking action.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.2 Blocking ID

This metric displays the blocking ID.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.3 Blocking Inst. Id

This metric displays the instance ID of the blocking concurrent program as available from the GV$LOCK view.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.4 Blocking Minutes

This metric displays the blocking minutes.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Concurrent Request %request_id% Blocked for %value% Minutes

7.4.5 Blocking Module

This metric displays the blocking module.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.6 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.7 Concurrent Request Inst. Id

This metric displays the ID associated with the concurrent request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.8 Concurrent Request SID

This metric displays the database SID associated with this concurrent request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.4.9 Request ID

This metric collects information on requests in blocked state (such as row locks) for a specific concurrent manager.

You can set an alert to inform you if a request is in blocked state for more than a specific threshold.

Target Version Collection Frequency
All Versions Every 60 Minutes

Data Source

Blocked requests are identified by joining FND_CONCURRENT_REQUESTS with GV$LOCK and GV$SESSION when the phase code of the request is 'R' for this concurrent manager.

User Action

Analyze the cause of the block and ensure that the issue is not widespread rather than just the concurrent request.

7.5 No. of Hourly Completed Requests by Status

This metric category provides the number of requests completed in the last hour grouped based on status.

7.5.1 Concurrent Requests Completed Successfully

This metric displays the number of concurrent requests that completed successfully in the last hour.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.5.2 Concurrent Requests Completed With Error

This metric displays the number of concurrent requests that completed with an error in the last hour.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined %value% concurrent requests completed with error

7.5.3 Concurrent Requests Completed With Warning

This metric displays the number of concurrent requests that completed with a warning in the last hour.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined %value% concurrent requests completed with warning

7.5.4 Concurrent Requests Error Rate (%)

This metric displays the percentage of completed concurrent requests with errors.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes 0 Not Defined Concurrent Requests completion with error rate is %value%%%

7.5.5 Concurrent Requests Successful Requests Rate (%)

This metric displays the percentage of successfully completed concurrent requests.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Concurrent Requests sucessful completion rate is %value%%%

7.5.6 Concurrent Requests Warning Rate (%)

This metric displays the percentage of completed concurrent requests with warnings.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Concurrent Requests completion with warning rate is %value%%%

7.6 No of Incomplete Requests by Status

This metric category provides the number of incomplete requests which are in various stages of progress, grouped by status.

7.6.1 Concurrent Requests Inactive (No Manager)

This metric displays the number of incomplete inactive concurrent requests with a status of No Manager.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined value% Concurrent Requests are Inactive (No Manager)

7.6.2 Concurrent Requests Inactive (On Hold)

This metric displays the number of incomplete inactive concurrent requests with a status of On Hold.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Concurrent Requests are on hold

7.6.3 Concurrent Requests Pending (Normal)

This metric displays the number of incomplete pending concurrent requests with a status of Normal.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Concurrent Requests are Pending (Normal)

7.6.4 Concurrent Requests Pending (Standby)

This metric displays the number of incomplete pending concurrent requests with a status of Standby.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Concurrent Requests are Pending (Standby)

7.6.5 Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

7.6.6 Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

7.7 Pending Requests (Standby)

This metric category provides informations about requests in a pending phase with a status of Standby.

7.7.1 Concurrent Program Name

This metric displays the name of the concurrent programs associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.7.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.7.3 Phase

This metric displays the request phase of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.7.4 Request Id

This metric displays the ID associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.7.5 Request Start Date

This metric displays the start date of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.7.6 Standby Pending Time

This metric displays the length of time that the request is pending with a status of Standby.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Request %request_id% Pending in Standby Status for %value% Minutes

7.7.7 Status

This metric displays the status of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8 Pending Requests (Normal)

This metric category provides information about requests in a pending phase with a status of Normal.

7.8.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8.3 Normal Pending Time

This metric displays the length of time that the request is pending in a Normal Status.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Request %request_id% Pending in Normal Status for %value% Minutes

7.8.4 Phase

This metric displays the request phase of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8.5 Request Id

This metric displays the ID associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8.6 Request Start Date

This metric displays the start date of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8.7 Status

This metric displays the status of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.8.8 Username

This metric displays the user name associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9 Running Requests

This metric category provides information about requests that are running.

7.9.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9.3 Phase

This metric displays the phase of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9.4 Request ID

This metric displays the ID associated with the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9.5 Request Start Date

This metric displays the start date of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9.6 Running Time

This metric displays the length of time that the concurrent request is running.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Request %request_id% Running for %value% Minutes

7.9.7 Status

This metric displays the status of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.9.8 Username

This metric displays the user name associated with the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.10 No of Concurrent Requests in Blocked State

This metric category provides information about the number of requests that are in a blocked state because of database locks.

7.10.1 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.10.2 No of Concurrent Requests in Blocked State

This metric displays the number of requests that are in a blocked state because of database locks.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined No of Concurrent Requests in Blocked State

7.11 Tolerance Level For Long Running Request

This metric category provides information about tolerance levels for long running requests. Tolerance level is calculated as a percentage of the running time to that of the average running time. This enables you to set an alert if the running time of a request exceeds a certain percentage of the average run time.

7.11.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.3 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.4 Phase

This metric displays the request phase of the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.5 Request ID

This metric displays the ID associated with the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.6 Request Start Date

This metric displays the start date of the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.7 Running Time

This metric displays the length of time that the request is running.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.8 Status

This metric displays the status of the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.11.9 Tolerance on Average Execution Time (%)

This metric displays the percentage of the running time to that of the average running time.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Request %request_id% is Running %value%% Longer Than The Average Execution Time

7.11.10 Username

This metric displays the user name associated with the long-running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.12 Running Request Sets

This metric category provides information about the running request sets. Request sets are defined to run several concurrent programs in a single request.

7.12.1 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.12.2 Phase

This metric displays the phase of the running request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.12.3 Request Id

This metric displays the ID associated with the running request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.12.4 Requested Start Date

This metric displays the start date of the running request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.12.5 Running Time

This metric displays the length of time that the request set is running.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Request %request_id% Running for %value% Minutes

7.12.6 Status

This metric displays the status of the running request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.13 Failed Request Sets

This metric category provides information about the failed request sets.

7.13.1 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Not Defined Failed Request Set name is %value%

7.13.2 Execution Time

This metric displays the length of time it took to complete the failed request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.13.3 Phase

This metric displays the phase of the failed request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.13.4 Request ID

This metric displays the ID associated with the failed request set

Target Version Collection Frequency
All Versions Every 60 Minutes

7.13.5 Requested Start Date

This metric displays the start date of the failed request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.13.6 Status

This metric displays the status of the failed request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.13.7 User Name

This metric displays the user name associated with the failed request set.

Target Version Collection Frequency
All Versions Every 60 Minutes

7.14 Not Started Request Sets

This metric category provides information about the request sets that have not started yet.

7.14.1 Concurrent Queue Name

This metric displays the name of the Concurrent Manager queue.

Target Version Collection Frequency
All Versions Every 20 Minutes

7.14.2 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version Collection Frequency
All Versions Every 20 Minutes

7.14.3 Request Id

This metric displays the ID associated with the request set that has not started yet.

Target Version Collection Frequency
All Versions Every 20 Minutes

7.14.4 Requested Start Date

This metric displays the start date of the request set that has not started yet.

Target Version Collection Frequency
All Versions Every 20 Minutes

7.14.5 Status

This metric displays the status of the request set that has not started yet.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 20 Minutes Not Defined Not Started Request Set %request_id% is not started since %requested_start_date%

7.14.6 User Name

This metric displays the user name associated the request set that has not started yet.

Target Version Collection Frequency
All Versions Every 20 Minutes

7.14.7 Wait Time

This metric displays the length of time the request set waits to be processed.

Target Version Collection Frequency
All Versions Every 20 Minutes

7.15 Unscheduled Request Sets

This metric category provides information about the request sets that are yet to be scheduled.

7.15.1 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version Collection Frequency
All Versions Every 24 Hours

7.15.2 Request Id

This metric displays the ID associated with the request set that has to be scheduled.

Target Version Collection Frequency
All Versions Every 24 Hours

7.15.3 Status

This metric displays the status of the request set that has to be scheduled.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 24 Hours Not Defined Unscheduled Request Set %request_id% is Unscheduled