Release 12.1.0.1.0
Part Number E28715-03
Contents
Previous
Next
| Oracle Application Management Pack for Oracle E-Business Suite Guide Release 12.1.0.1.0 Part Number E28715-03 | Contents | Previous | Next |
The Concurrent Processing Dashboard provides you with details in concurrent processing in your Oracle E-Business Suite system. The dashboard gives you a complete picture of concurrent processing on your system, both current activities as well as usage statistics.
The Concurrent Processing Dashboard is available from the Performance tab of the main page for an Oracle E-Business Suite instance, under Concurrent Processing.
You can add a user-defined concurrent program as a target to the Oracle E-Business Suite composite target. You can then monitor related activities of the registered individual concurrent programs for your own specified thresholds.
You can also add a user-defined concurrent manager as a target to the Oracle E-Business Suite composite target. You can then monitor related activities of the registered individual concurrent managers for your own specified thresholds.
In addition to the features described in this chapter, links are provided under Related Links for the following Oracle Application Manager features:
Concurrent Request Runaways
Concurrent Processing Reports
Concurrent Processing Charts
The General region lists the status of the Concurrent Processing Service
Status - The status is linked to the Concurrent Processing Service home page.
Active Service Processes - Number of active service processes.
User-defined Concurrent Program Targets - Defining these targets is described in a later section.
Configured Concurrent Managers - The number of configured concurrent managers.
The Hourly Completed Requests region shows a pie chart for requests by status (Successful, Warning, and Errored).
The Activity Summary graph illustrates active requests in the following statuses
Pending Normal
Pending Standby
Running
The Components region lists components of the Concurrent Processing service. The table shows the following for each component:
Name
Type
Status
Incidents
Host
The Incidents region lists any incidents that were triggered recently, with the following information for each:
Severity
Metric
Target Name
Target Type
Incident Triggered
Last Value
Last Checked
At the bottom of the dashboard are Related Links:
The first three links provide metrics on requests and processes:
Hourly Completed Requests
Processes and Requests per Concurrent Manager
Active Concurrent Requests by Application
The last three links take you to Oracle Applications Manager pages for the Oracle E-Business Suite instance:
Concurrent Request Runaways
Concurrent Processing Reports
Concurrent Processing Charts
The Concurrent Requests by Status region lists the number of requests for each status:
Pending Normal
Pending (Standby)
Scheduled
Inactive (No Manager)
On Hold
Running
Click on the number for a status to find out more about the metric trend.
The Hourly Completed Requests region lists statistics for requests that have completed in the past hour, including:
Successful
Warning
Error
Successful Requests Rate (%)
Requests Warning Rate (%)
Requests Error Rate (%)
Click on the number for each statistic to find out more details.
The Concurrent Managers by Requests lists all concurrent managers, in order of the number of requests it has in the specified status, either Running or Pending.
With "Running" selected, the following is shown for each concurrent manager:
Service Name
Service Short Name
Application Name
Status
Running Requests
Service Handle
Service Target Processes
Service Actual Processes
With "Pending" selected, the following is shown for each concurrent manager:
Service Name
Service Short Name
Application Name
Status
Normal Pending Requests
Standby Pending Requests
Service Handle
Service Target Processes
Service Actual Processes
The Top Concurrent Requests region shows the top ten (10) requests for the specified status of Running, Pending, or Scheduled.
Running - These are sorted by running time in descending order.
Pending - These are sorted by running time in descending order.
Scheduled - These are sorted by their scheduled start time.
The Top Applications region lists the top ten (10) applications for running requests or pending requests, as specified.
The Top Users region lists the top ten (10) users by number of running or pending requests, as specified.
This tab provides a summary of how the concurrent programs and managers have been utilized over a period of time.
The top ten (10) concurrent requests for the following categories are listed:
Number of executions - For this category, the total number of executions, the percentage (%) of successful executions, and the percentage (%) of errored executions are shown.
Number of failed executions - The number of executions, percentage (%) of failed executions, and percentage (%) of errored executions are shown.
Average run time in minutes - The number of executions, average running time (minutes), and total running time (minutes) are shown.
Total run time in minutes - The top ten (10) programs with the highest maximum running time are shown. For each program listed, the number of executions, total running time (minutes) and percentage (%) of successful executions are shown.
The top ten (10) applications for the following categories are listed:
Number of executions
Number of failed executions
The top ten (10) users by total number of requests are also listed, in descending order of number of requests.
You can add concurrent managers and programs as targets to monitor. Use this tab to get details about these targets as well as add more custom targets.
For custom concurrent program targets, the following columns are shown:
Name
Concurrent Program Short Name
Incidents
Host
Click on "Show" in the Details column to see the following metrics for the given concurrent program target. (More details can be seen from the Target home page > All Metrics):
Number of Concurrent Requests by Status
Number of Hourly Completed Requests
Requests Completed with Error
Long-Pending Requests
Long-Running Requests
Use the Add button under Concurrent Programs to add a new program target.
For concurrent manager targets, the following columns are shown:
Name
Concurrent Manager Short Name
Incidents
Host
Click on "Show" in the Details column to see the following for the given concurrent manager target:
Active Processes
Running Requests
Pending Requests
Use the Add button under Concurrent Managers to add a new manager target.
You can add a concurrent program custom target so that the system will collect metrics on activity and usage for the concurrent program.
Note: You cannot add a custom concurrent program target using Internet Explorer 8. Please use a different version, or different browser such as Mozilla Firefox.
To add a concurrent program custom target, navigate to the Concurrent Processing Dashboard, User Defined Targets tab, and click Add under Concurrent Programs.
For your new target, define the following:
Target Name Prefix - This value is determined by the system based on the instance name and cannot be updated.
Target Name - Enter in a target name "suffix". The actual target name will be composed of the Target Name Prefix (above) and the value of this field.
Target Type - The system automatically provides the value "Custom Oracle Concurrent Program".
Concurrent Program Short Name - Use the LOV icon to search for and select the program short name. In searching for the program name you can search by concurrent program short name, concurrent program name, or application.
Monitoring Host
For the Basic Properties region, values for the following should default in. These values are used as credentials by the target for metrics collection:
SID
Machine
Port
(Database) User name
(Database) Password
ConnectString
For metrics collection, you need to define the thresholds for several metrics. Define instance parameters that will be used to categorize requests for the following:
A request will be termed Long Pending if it is in Pending status for longer than the "Long Pending Request Threshold In Minutes".
A request will be considered Long Running if it runs for longer than the "Long Running Request Threshold In Minutes" and (1+0.1*"Long Running Tolerance Percentage")*Average Running Time of the Concurrent Program.
When you are done, click Add to add the target.
Once you have added a custom concurrent program target, you can monitor it. It should be listed on the User Defined Targets tab. Click on its name link to view details.
Click on the Show link under Details for links to drill down on the following:
Number of Concurrent Requests by Status
Number of Hourly Completed Requests
Requests Completed with Error
Long Pending Requests
Long Running Requests
From here, you can access the metrics collected for this target by navigating to Target menu > Monitoring > All Metrics. The collected metrics are listed below.
The following metrics are collected:
This page lists metrics for the following:
Requests Completed Successfully
Requests Completed with Warnings
Requests Completed with Errors
Minimum Run Time
Maximum Run Time
Average Run Time
The numbers for requests in each status below are listed.
Concurrent Requests Pending (Normal)
Concurrent Requests Pending (Standby)
Concurrent Requests Scheduled
Concurrent Requests Inactive (No Manager)
Concurrent Requests Inactive (On Hold)
Concurrent Requests Running
Concurrent Requests Completed Successfully
Concurrent Requests Completed With Warning
Concurrent Requests With Error
Concurrent Requests Successful Requests Rate (%)
Concurrent Requests Warning Rate (%)
Concurrent Requests Error Rate (%)
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Pending Time
Concurrent Manager
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Running Time
Concurrent Manager
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Pending Time
Concurrent Manager
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Execution Time
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Execution Time
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Running Time
Concurrent Manager
You can add a concurrent manager custom target so that the system will collect metrics on activity and usage for requests run by the concurrent manager.
To add a concurrent manager custom target, navigate to the Concurrent Processing Dashboard > User Defined Targets tab, and click Add under Concurrent Manager.
For your new target, define the following:
Target Name Prefix - This value is determined by the system based on the instance name and cannot be updated.
Target Name - Enter in a target name "suffix". The actual target name will be composed of the Target Name Prefix (above) and the value of this field.
Target Type - The system automatically provides the value "Custom Oracle Concurrent Manager".
Concurrent Manager Short Name - Use the LOV icon to search for and select the concurrent manager short name. In searching for the manager name you can search by concurrent manager short name, concurrent manager name, or application.
Monitoring Host
For the Basic Properties region, values for the following should default in. These values are used as credentials by the target for metrics collection:
SID
Machine
Port
(Database) User name
(Database) Password
ConnectString
For metrics collection, you need to specify values for three Instance Properties that will be used to categorize requests for the following:
A request will be termed Long Pending if it is in Pending status for longer than the "Long Pending Request Threshold In Minutes".
A request will be considered Long Running if it runs for longer than the "Long Running Request Threshold In Minutes" and (1+0.1*"Long Running Tolerance Percentage")*Average Running Time of the Concurrent Program.
You can also change these properties by clicking the "Monitoring Configuration" link on the Target Home page.
When you are done, click Add to add the target.
Once you have added a custom concurrent manager target, you can monitor for it. It should be listed on the User Defined Targets tab. Click on its name link to view details.
From here, you can also monitor the metrics for this target by navigating to Target menu > Monitoring > All Metrics.
Target Node
OS Process ID
Session ID
Process Status
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Pending Time
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Running Time
This section lists the concurrent processing metrics available from the All Metrics page. Navigate to the All Metrics page by selecting Target menu > Monitoring > All Metrics.
For each type of metric below, the details listed for each record are shown.
Application Short Name
Application Name
Non-Repeating Pending Requests (Normal and Standby)
Repeating Pending Requests (Normal and Standby)
Non-Repeating Running Requests
Repeating Running Requests
Application Short Name
Application Name
Total Executions
Errored Executions
Errored Executions (%)
Application Short Name
Application Name
Total Executions
Successful Executions (%)
Errored Executions (%)
Application Short Name
Application Name
Number of Pending Requests
Application Short Name
Application Name
Number of Running Requests
Concurrent Program Name
User Concurrent Program Name
Total Executions
Average Running Time
Maximum Running Time
Concurrent Program Name
User Concurrent Program Name
Total Executions
Total Executions (Errored)
Executions Errored (%)
Concurrent Program Name
User Concurrent Program Name
Total Executions
Successful Executions (%)
Errored Executions (%)
Concurrent Program Name
User Concurrent Program Name
Total Executions
Total Running Time
Successful Executions (%)
Request ID
Program Name
Program Short Name
Request Start Date
Pending Time
User Name
Manager Name
Phase
Status
Request ID
Program Name
Program Short Name
Request Start Date
Running Time
User Name
Manager Name
Phase
Status
Request ID
Program Name
Program Short Name
Request Start Date
Scheduled to Run In (Minutes)
User Name
Manager Name
Phase
Status
User Name
Number of Requests
User Name
Number of Pending Requests
User Name
Number of Running Requests
Oracle Application Management Pack for Oracle E-Business Suite allows you to define parameters for long running and long pending requests. Follow the procedure below to do so.
From the Concurrent Processing Dashboard, add a custom concurrent program or concurrent manager target.
For the custom target, enter in values for these fields:
Long Pending Request Threshold in Minutes
Long Running Request Threshold in Minutes
Long Running Tolerance Percentage
The three parameters above are instance parameters for categorizing a request as long running or long pending.
A request will be considered long pending if it is pending for more than the "Long Pending Threshold in Minutes" value.
A request will be considered long running if it runs for more than the "Long Running Request Threshold in Minutes" value AND for longer than (1 + 0.01*[Long Running Tolerance Percentage]*[Average Running Time of the Concurrent Program]).
After you have set these parameters, you can go to the All Metrics page to see these categories listed. Navigate to the All Metrics page by navigating to the Target Menu, selecting Monitoring, then selecting All Metrics.
For Long Pending Requests, the following details are available through drilling down:
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Pending Time
Concurrent Manager
For Long Running Requests, the following are available through drilling down:
Request ID
Concurrent Program Short Name
Concurrent Program Name
Request Start Date
Username
Phase
Status
Running Time
Concurrent Manager
For Long Running and Long Pending Requests, you can drill down to get a count for each.
On the same All Metrics page, click on Metric and Policy Settings to edit the incident threshold for long pending and long running requests. Choose to view "All Metrics" from the View dropdown list and set the incidents count for Long Pending Requests and Long Running Requests.
Copyright © 2007, 2012, Oracle and/or its affiliates. All rights reserved.