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.
This metric category collects information about active concurrent requests by application.
This metric is computed by counting the total active concurrent requests by application from the FND_CONCURRENT_REQUESTS table.
This metric displays the name of the application.
Target Version | Collection Frequency |
---|---|
All Versions | Every 15 Minutes |
This metric displays the short name of the application.
Target Version | Collection Frequency |
---|---|
All Versions | Every 15 Minutes |
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% |
If there are an unusually high number of pending requests, then check if all the concurrent managers are active.
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% |
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% |
If there are an unusually high number of pending requests, then check if all the concurrent managers are active.
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% |
This metric category provides information about active concurrent requests.
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.
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.
The number of instances per manager and the maximum instances allowed per manager is obtained from FND_CONCURRENT_QUEUES and the percentage is calculated.
This metric displays the name of the concurrent manager.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
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%% |
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.
This metric displays the blocking action.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the blocking ID.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
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 |
This metric displays the blocking module.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the name of the concurrent program.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the concurrent request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the database SID associated with this concurrent request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
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.
Analyze the cause of the block and ensure that the issue is not widespread rather than just the concurrent request.
This metric category provides the number of requests completed in the last hour grouped based on status.
This metric displays the number of concurrent requests that completed successfully in the last hour.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
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 |
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%%% |
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%%% |
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%%% |
This metric category provides the number of incomplete requests which are in various stages of progress, grouped by status.
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) |
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 |
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) |
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) |
This metric category provides informations about requests in a pending phase with a status of Standby.
This metric displays the name of the concurrent programs associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the short name of the concurrent program associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the request phase of the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the start date of the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
This metric category provides information about requests in a pending phase with a status of Normal.
This metric displays the name of the concurrent program associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the short name of the concurrent program associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
This metric displays the request phase of the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the start date of the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric category provides information about requests that are running.
This metric displays the name of the concurrent program associated with the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the short name of the concurrent program associated with the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the phase of the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the start date of the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
This metric category provides information about the number of requests that are in a blocked state because of database locks.
This metric displays the name of the concurrent program.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
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.
This metric displays the name of the concurrent manager associated with the long-running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the name of the concurrent program associated with the long-running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
This metric displays the request phase of the long-running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the long-running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the start date of the long-running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the length of time that the request is running.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the status of the long-running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
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 |
This metric category provides information about the running request sets. Request sets are defined to run several concurrent programs in a single request.
This metric displays the name of the concurrent request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the phase of the running request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the running request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the start date of the running request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric category provides information about the failed request sets.
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% |
This metric displays the length of time it took to complete the failed request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the phase of the failed request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the ID associated with the failed request set
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric displays the start date of the failed request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 60 Minutes |
This metric category provides information about the request sets that have not started yet.
This metric displays the name of the Concurrent Manager queue.
Target Version | Collection Frequency |
---|---|
All Versions | Every 20 Minutes |
This metric displays the name of the concurrent request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 20 Minutes |
This metric displays the ID associated with the request set that has not started yet.
Target Version | Collection Frequency |
---|---|
All Versions | Every 20 Minutes |
This metric displays the start date of the request set that has not started yet.
Target Version | Collection Frequency |
---|---|
All Versions | Every 20 Minutes |
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% |
This metric category provides information about the request sets that are yet to be scheduled.
This metric displays the name of the concurrent request set.
Target Version | Collection Frequency |
---|---|
All Versions | Every 24 Hours |