A 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. This chapter provides information about the metrics defined for the Custom Oracle Concurrent Manager. These metrics are also applicable to Oracle-delivered Concurrent Managers.
For more information about concurrent managers, see your Oracle E-Business Suite user documentation.
This metric category provides information about the operating system (OS) processes associated with this concurrent manager on a node.
This metric displays the OS Process Id associated with the concurrent request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the status of the process.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions | Every 15 Minutes | 0 | Not Defined | %value% Active Processes |
This metric category provides information about the capacity utilization of this concurrent manager.
This metric displays the name of the concurrent manager.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric compares the number of instances of concurrent managers running to the maximum number allowed instances and computes the capacity as a percentage of maximum allowed. This is calculated for a specific concurrent manager type. You can set an alert if the capacity utilization of concurrent managers drops below a specific threshold.
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%%" MESSAGE_NLSID="ebiz_capacity_utilization |
The number of instances per manager and the maximum number of allowed instances per manager is obtained from FND_CONCURRENT_QUEUES and the percentage is calculated.
This metric category provides information about concurrent requests in a blocked state for this concurrent manager.
This metric displays the blocking action for the requests in a blocked state for this concurrent manager.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the blocking ID associated with the request in a blocked state.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
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 1 Hour |
This metric displays the number of minutes that the request is in a blocked state.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions | Every 1 Hour | Not Defined | Not Defined | Concurrent Request %request_id% Blocked for %value% Minutes |
This metric displays the module to which the blocking concurrent program belongs.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the name of the concurrent program.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the ID associated with the concurrent request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the database SID associated with this concurrent request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric collects information on requests in a 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 1 Hour |
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.
This metric category is used to collect information about concurrent requests by status for custom concurrent manager.
This metric displays the number of 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% Requests are On Hold |
This metric displays the number of 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% Requests are Pending Normal |
This metric displays the number of 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% Requests are Pending Standby |
This metric category provides the number of requests being processed by this manager, that are in a blocked state due to 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 | %value% Concurrent Request are in Blocked State |
This metric category provides information about the number of specialization rules for a concurrent manager. You can set thresholds to generate alerts if the number of rules exceeds a specific limit.
This metric displays the application ID associated with the current application.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the name of the concurrent queue.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the manager that is defined to read the request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric category provides information about the requests with this Concurrent Manager that are 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 1 Hour |
This metric displays the name of the concurrent program associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the length of time that the request is pending.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions | Every 1 Hour | 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 1 Hour |
This metric displays the ID associated with the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the start date of the pending request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric category provides information about the requests with this Concurrent Manager, that are in Pending phase with a status of Standby.
This metric displays the name of the concurrent program associated with the pending request with a status of Standby.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the short name of the concurrent program associated with the pending request with a status of Standby.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the request phase of the pending request with a status of Standby.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the ID associated with the pending request with a status of Standby.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
This metric displays the start date of the pending request with a status of Standby.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Hour |
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 1 Hour | Not Defined | Not Defined | Request %request_id% Pending in Standby Status for %value% Minutes |
This metric category provides information about the status of the Custom Oracle Concurrent Manager target.
This metric category provides information about the requests that are being run by this concurrent manager.
This metric displays the name of the concurrent program associated with the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the short name of the concurrent program associated with the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the phase of the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the ID associated with the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
This metric displays the start date of the running request.
Target Version | Collection Frequency |
---|---|
All Versions | Every 1 Day |
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 15 Minutes | Not Defined | Not Defined | Request %request_id% Running for %value% Minutes |
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 of all requests processed by this manager. This allows 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 |