1 Custom Oracle Concurrent Manager

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.

1.1 Active Processes

This metric category provides information about the operating system (OS) processes associated with this concurrent manager on a node.

1.1.1 OS Process ID

This metric displays the OS Process Id associated with the concurrent request.

Target Version Collection Frequency
All Versions Every 1 Day

1.1.2 Process Status

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

1.1.3 Session Id

This metric displays the session ID of the process.

Target Version Collection Frequency
All Versions Every 1 Day

1.1.4 Target Node

This metric displays the node where the concurrent program is running.

Target Version Collection Frequency
All Versions Every 1 Day

1.2 Capacity Utilization of Concurrent Managers

This metric category provides information about the capacity utilization of this concurrent manager.

1.2.1 Manager Name

This metric displays the name of the concurrent manager.

Target Version Collection Frequency
All Versions Every 1 Day

1.2.2 Utilized Capacity

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

Data Source

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.

1.3 Concurrent Requests in Blocked State

This metric category provides information about concurrent requests in a blocked state for this concurrent manager.

1.3.1 Blocking Action

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

1.3.2 Blocking Id

This metric displays the blocking ID associated with the request in a blocked state.

Target Version Collection Frequency
All Versions Every 1 Hour

1.3.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 1 Hour

1.3.4 Blocking Minutes

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

1.3.5 Blocking Module

This metric displays the module to which the blocking concurrent program belongs.

Target Version Collection Frequency
All Versions Every 1 Hour

1.3.6 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Hour

1.3.7 Concurrent Request Inst. Id

This metric displays the ID associated with the concurrent request.

Target Version Collection Frequency
All Versions Every 1 Hour

1.3.8 Concurrent Request SID

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

Target Version Collection Frequency
All Versions Every 1 Hour

1.3.9 Request Id

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

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.

1.4 Concurrent Requests by Status

This metric category is used to collect information about concurrent requests by status for custom concurrent manager.

1.4.1 Concurrent Requests Inactive (On Hold)

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

1.4.2 Concurrent Requests Pending (Normal)

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

1.4.3 Concurrent Requests Pending (Standby)

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

1.4.4 Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

1.4.5 Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

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

1.5 No of Concurrent Requests in Blocked State

This metric category provides the number of requests being processed by this manager, that are in a blocked state due to database locks.

1.5.1 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

1.5.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 %value% Concurrent Request are in Blocked State

1.6 No. of Include and Exclude Specialization Rules

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.

1.6.1 Application Id

This metric displays the application ID associated with the current application.

Target Version Collection Frequency
All Versions Every 1 Day

1.6.2 Concurrent Queue Name

This metric displays the name of the concurrent queue.

Target Version Collection Frequency
All Versions Every 1 Day

1.6.3 Manager

This metric displays the manager that is defined to read the request.

Target Version Collection Frequency
All Versions Every 1 Day

1.6.4 Total Exclude Rules

This metric displays the total number of Exclude specialization rules.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value% Exclude Specialization Rules

1.6.5 Total Include Rules

This metric displays the total number of Include specialization rules.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value% Include Specialization Rules

1.7 Pending Requests (Normal)

This metric category provides information about the requests with this Concurrent Manager that are in a Pending phase, with a status of Normal

1.7.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 1 Hour

1.7.2 Concurrent Program Short Name

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

Target Version Collection Frequency
All Versions Every 1 Hour

1.7.3 Normal Pending Time

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

1.7.4 Phase

This metric displays the request phase of the pending request.

Target Version Collection Frequency
All Versions Every 1 Hour

1.7.5 Request ID

This metric displays the ID associated with the pending request.

Target Version Collection Frequency
All Versions Every 1 Hour

1.7.6 Request Start Date

This metric displays the start date of the pending request.

Target Version Collection Frequency
All Versions Every 1 Hour

1.7.7 Status

This metric displays the status of the pending request.

Target Version Collection Frequency
All Versions Every 1 Hour

1.7.8 Username

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

Target Version Collection Frequency
All Versions Every 1 Hour

1.8 Pending Requests (Standby)

This metric category provides information about the requests with this Concurrent Manager, that are in Pending phase with a status of Standby.

1.8.1 Concurrent Program Name

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

1.8.2 Concurrent Program Short Name

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

1.8.3 Phase

This metric displays the request phase of the pending request with a status of Standby.

Target Version Collection Frequency
All Versions Every 1 Hour

1.8.4 Request Id

This metric displays the ID associated with the pending request with a status of Standby.

Target Version Collection Frequency
All Versions Every 1 Hour

1.8.5 Request Start Date

This metric displays the start date of the pending request with a status of Standby.

Target Version Collection Frequency
All Versions Every 1 Hour

1.8.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 1 Hour Not Defined Not Defined Request %request_id% Pending in Standby Status for %value% Minutes

1.8.7 Status

This metric displays the status of the pending request with a status of Standby.

Target Version Collection Frequency
All Versions Every 1 Hour

1.8.8 Username

This metric displays the user name associated with the pending request with a status of Standby.

Target Version Collection Frequency
All Versions Every 1 Hour

1.9 Response

This metric category provides information about the status of the Custom Oracle Concurrent Manager target.

1.9.1 Status

This metric specifies whether the Concurrent Manager is up and running.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined 0 Database is down

User Action

Check if the Concurrent Manager is up.

1.10 Running Requests

This metric category provides information about the requests that are being run by this concurrent manager.

1.10.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 1 Day

1.10.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 1 Day

1.10.3 Phase

This metric displays the phase of the running request.

Target Version Collection Frequency
All Versions Every 1 Day

1.10.4 Request ID

This metric displays the ID associated with the running request.

Target Version Collection Frequency
All Versions Every 1 Day

1.10.5 Request Start Date

This metric displays the start date of the running request.

Target Version Collection Frequency
All Versions Every 1 Day

1.10.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 15 Minutes Not Defined Not Defined Request %request_id% Running for %value% Minutes

1.10.7 Status

This metric displays the status of the running request.

Target Version Collection Frequency
All Versions Every 1 Day

1.10.8 Username

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

Target Version Collection Frequency
All Versions Every 1 Day

1.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 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.

1.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

1.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

1.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

1.11.4 Phase

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

Target Version Collection Frequency
All Versions Every 60 Minutes

1.11.5 Request Id

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

Target Version Collection Frequency
All Versions Every 60 Minutes

1.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

1.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

1.11.8 Status

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

Target Version Collection Frequency
All Versions Every 60 Minutes

1.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

1.11.10 Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes