2 Custom Oracle Concurrent Program

This chapter provides information about the metrics defined for the Custom Oracle Concurrent Program target. These metrics are also applicable for Oracle-delivered concurrent programs.

For information about concurrent programs, see your Oracle E-Business Suite user documentation.

2.1 Basic Information

This metric category provides basic information about specific concurrent programs.

2.1.1 Average Run Time

This metric displays the average run time for a task.

Target Version Collection Frequency
All Versions Every 1 Day

2.1.2 Maximum Run Time

This metric displays the maximum run time for a task.

Target Version Collection Frequency
All Versions Every 1 Day

2.1.3 Minimum Run Time

This metric displays the minimum run time for a task.

Target Version Collection Frequency
All Versions Every 1 Day

2.1.4 Requests Completed Successfully

This metric displays the number of successful requests completed to run tasks.

Target Version Collection Frequency
All Versions Every 1 Day

2.1.5 Requests Completed with Errors

This metric displays the number of requests with errors completed to run tasks.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Requests Completed with Errors"

2.1.6 Requests Completed with Warnings

This metric displays the number of requests completed with warnings to run tasks.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value% Requests Completed with Warnings

2.2 Concurrent Requests in Blocked State

This metric category provides information about the requests of this program that are in a blocked state due to database locks.

2.2.1 Blocking Action

This metric displays the blocking action for the requests in a blocked state for this concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.2.2 Blocking Id

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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

2.2.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 60 Minutes Not Defined Not Defined Concurrent Request %request_id% Blocked for %value% Minutes

2.2.5 Blocking Module

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.2.6 Concurrent Program Name

This metric displays the name of the concurrent program

Target Version Collection Frequency
All Versions Every 60 Minutes

2.2.7 Concurrent Request Inst. Id

This metric displays the ID associated with the concurrent request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.2.8 Concurrent Request SID

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.2.9 Request Id

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.3 Monitor Schedule for Requests

This metric category collects the monitoring schedule of a specific concurrent program. You can set an alert if the concurrent program is not scheduled as per the recommend duration.

Data Source

The schedule for a concurrent program is available from the FND_CONCURRENT_REQUESTS table.

2.3.1 Concurrent Program Name

This metric displays the name of this concurrent program.

Target Version Collection Frequency
All Versions Every Day

2.3.2 Concurrent Program Short Name

This metric displays the short name of this concurrent program.

Target Version Collection Frequency
All Versions Every Day

2.3.3 Request Id

This metric displays the request ID.

Target Version Collection Frequency
All Versions Every Day

2.3.4 Resubmit Interval Days

This metric displays the interval in days between resubmissions.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every Day Not Defined Not Defined Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Days

2.3.5 Resubmit Interval Hours

This metric displays the interval in hours between resubmissions.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every Day Not Defined Not Defined Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Hours

2.3.6 Resubmit Interval Minutes

This metric displays the interval in minutes between resubmissions.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every Day Not Defined Not Defined Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Minutes

2.3.7 Resubmit Interval Months

This metric displays the interval in months between resubmissions.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every Day Not Defined Not Defined Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Months

2.3.8 Resubmit Interval Unit Code

This metric displays the unit code of the resubmission interval.

Target Version Collection Frequency
All Versions Every Day

2.4 No. of Incomplete Requests by Status

This metric category provides information about the number of requests of this program, which are in various stages of progress grouped by status.

2.4.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)

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

2.4.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)

2.4.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)

2.4.5 Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

2.4.6 Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

2.5 No. of Hourly Completed Requests by Status

This metric category provides information about the number of requests of this program completed in the last one hour grouped by status.

2.5.1 Concurrent Requests Completed Successfully

This metric displays the number of concurrent requests completed successfully.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.5.2 Concurrent Requests Completed With Error

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

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

2.5.3 Concurrent Requests Completed With Warning

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

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

2.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 60 Minutes Not Defined Not Defined Concurrent Requests completion with error rate is %value%%%

2.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 %value% Concurrent Requests are Pending (Standby)

2.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%%%

2.6 No. of Concurrent Requests in Blocked State

This metric category provides information about the number of requests of this program which are in a blocked state due to database locks.

2.6.1 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.6.2 Total Blocked Requests

This metric displays the total number of concurrent requests that are in a blocked state due to database locks.

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

2.7 Pending Requests (Standby)

This metric category provides information about requests of this program that are in Pending phase with a status of Standby.

2.7.1 Concurrent Manager

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.7.2 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 60 Minutes

2.7.3 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 60 Minutes

2.7.4 Phase

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.7.5 Request Id

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.7.6 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 60 Minutes

2.7.7 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

2.7.8 Status

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.7.9 Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.8 Pending Requests (Normal)

This metric category provides information about the requests of this program that are in a pending phase with status of Normal.

2.8.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the pending request with a status of Normal.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.8.2 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

2.8.3 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 60 Minutes

2.8.4 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 60 Minutes Not Defined Not Defined Request %request_id% Pending in Normal Status for %value% Minutes

2.8.5 Phase

This metric displays the request phase of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.8.6 Request Id

This metric displays the ID associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.8.7 Request Start Date

This metric displays the start date of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.8.8 Status

This metric displays the status of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.8.9 Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.9 Requests Completed with Error

This metric category provides information about the concurrent requests that completed with errors.

2.9.1 Concurrent Program Name

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

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined Request %request_id% Completed with Error for program %value%

2.9.2 Concurrent Program Short Name

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

Target Version Collection Frequency
All Versions Every 1 Hour

2.9.3 Execution Time

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

Target Version Collection Frequency
All Versions Every 1 Hour

2.9.4 Phase

This metric displays the phase of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

2.9.5 Request ID

This metric displays the ID associated with the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

2.9.6 Request Start Date

This metric displays the start date of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

2.9.7 Status

This metric displays the status of the completed request.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined Request %request_id% Completed with Error for program %program_name%

2.9.8 Username

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

Target Version Collection Frequency
All Versions Every 1 Hour

2.10 Requests Completed Successfully

This metric category provides information about the requests completed successfully in the last five minutes. This metric category is disabled by default to avoid performance issues.

2.10.1 Concurrent Program Name

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

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.2 Concurrent Program Short Name

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

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.3 Execution Time

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

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.4 Phase

This metric displays the phase of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.5 Request End Date

This metric displays the end date of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.6 Request Id

This metric displays the ID associated with the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.7 Request Start Date

This metric displays the start date of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.8 Status

This metric displays the status of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

2.10.9 Username

This metric displays the user name associated with the request

Target Version Collection Frequency
All Versions Every 5 Minutes

2.11 Requests Completed with Warning

This metric category provides information about the concurrent requests that completed with warnings.

2.11.1 Concurrent Program Name

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

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined Request %request_id% Completed with Warning for program %value%

2.11.2 Concurrent Program Short Name

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

Target Version Collection Frequency
All Versions Every 1 Hour

2.11.3 Execution Time

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

Target Version Collection Frequency
All Versions Every 1 Hour

2.11.4 Phase

This metric displays the phase of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

2.11.5 Request ID

This metric displays the ID associated with the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

2.11.6 Request Start Date

This metric displays the start date of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

2.11.7 Status

This metric displays the status of the completed request.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined Request %request_id% Completed with Warning for program %program_name%

2.11.8 Username

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

Target Version Collection Frequency
All Versions Every 1 Hour

2.12 Response

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

2.12.1 Status

This metric specifies whether the target 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

2.13 Running Requests

This metric category provides information about the requests that are being run.

2.13.1 Concurrent Manager

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.13.2 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

2.13.3 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

2.13.4 Phase

This metric displays the phase of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.13.5 Request Id

This metric displays the ID associated with the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.13.6 Request Start Date

This metric displays the start date of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.13.7 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

2.13.8 Status

This metric displays the status of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

2.13.9 Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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

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

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

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

2.14.4 Phase

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.14.5 Request Id

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.14.6 Request Start Date

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.14.7 Running Time

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.14.8 Status

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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

2.14.10 Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

2.15 Unscheduled Requests

This metric category provides information about unscheduled requests.

2.15.1 Concurrent Program Name

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

Target Version Collection Frequency
All Versions Every Day

2.15.2 Concurrent Program Short Name

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

Target Version Collection Frequency
All Versions Every Day

2.15.3 Repeating schedule Request

This metric checks if a concurrent program is scheduled or not. If you set the threshold as 0, then this means that the concurrent program is not scheduled and Enterprise Manager raises an alert.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every Day Not Defined Not Defined The concurrent program %program_display_name% is not scheduled.

Datasource

The FND_CONCURRENT_REQUESTS table contains an entry if a concurrent program is scheduled.

User Action

Schedule the program.