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.

This chapter covers the following topics:

Basic Information

This metric category provides basic information about specific concurrent programs.

Average Run Time

This metric displays the average run time for a task.

Target Version Collection Frequency
All Versions Every 1 Day

Maximum Run Time

This metric displays the maximum run time for a task.

Target Version Collection Frequency
All Versions Every 1 Day

Minimum Run Time

This metric displays the minimum run time for a task.

Target Version Collection Frequency
All Versions Every 1 Day

Requests Completed Successfully

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

Target Version Collection Frequency
All Versions Every 1 Day

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

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

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.

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

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

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

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

Blocking Module

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

Concurrent Request Inst. ID

This metric displays the ID associated with the concurrent request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Concurrent Request SID

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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

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.

Concurrent Program Name

This metric displays the name of this concurrent program.

Target Version Collection Frequency
All Versions Every Day

Concurrent Program Short Name

This metric displays the short name of this concurrent program.

Target Version Collection Frequency
All Versions Every Day

Request ID

This metric displays the request ID.

Target Version Collection Frequency
All Versions Every Day

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

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

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

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

Resubmit Interval Unit Code

This metric displays the unit code of the resubmission interval.

Target Version Collection Frequency
All Versions Every Day

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.

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)

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

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)

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)

Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

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.

Concurrent Requests Completed Successfully

This metric displays the number of concurrent requests completed successfully.

Target Version Collection Frequency
All Versions Every 60 Minutes

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

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

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

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)

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

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.

Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version Collection Frequency
All Versions Every 60 Minutes

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

Pending Requests (Standby)

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

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

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

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

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

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

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

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

Status

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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

Pending Requests (Normal)

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

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

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

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

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

Phase

This metric displays the request phase of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Request ID

This metric displays the ID associated with the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Request Start Date

This metric displays the start date of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Status

This metric displays the status of the pending request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Requests Completed with Error

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

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%

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

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

Phase

This metric displays the phase of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

Request ID

This metric displays the ID associated with the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

Request Start Date

This metric displays the start date of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

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%

Username

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

Target Version Collection Frequency
All Versions Every 1 Hour

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.

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

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

Execution Time

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

Target Version Collection Frequency
All Versions Every 5 Minutes

Phase

This metric displays the phase of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

Request End Date

This metric displays the end date of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

Request ID

This metric displays the ID associated with the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

Request Start Date

This metric displays the status of the running request.

Target Version Collection Frequency
All Versions Every 5 Minutes

Status

This metric displays the status of the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

Username

This metric displays the user name associated with the request.

Target Version Collection Frequency
All Versions Every 5 Minutes

Requests Completed with Warning

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

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%

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

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

Phase

This metric displays the phase of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

Request ID

This metric displays the ID associated with the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

Request Start Date

This metric displays the start date of the completed request.

Target Version Collection Frequency
All Versions Every 1 Hour

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%

Username

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

Target Version Collection Frequency
All Versions Every 1 Hour

Response

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

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

Running Requests

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

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

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

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

Phase

This metric displays the phase of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Request ID

This metric displays the ID associated with the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Request Start Date

This metric displays the start date of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Running Time

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

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

Status

This metric displays the status of the running request.

Target Version Collection Frequency
All Versions Every 60 Minutes

Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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.

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

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

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

Phase

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Request ID

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Request Start Date

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Running Time

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Status

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

Target Version Collection Frequency
All Versions Every 60 Minutes

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

Username

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

Target Version Collection Frequency
All Versions Every 60 Minutes

Unscheduled Requests

This metric category provides information about unscheduled requests.

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

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

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.