This section includes the following topics:
The Oracle Applications tab displays details about the current status of the Concurrent Managers and Requests (batch jobs and reports) that have been submitted. It also displays historical information on the availability of the managers and completion of requests. It has a structure similar to the Dashboard tab, allowing you to quickly monitor the health of your Oracle Applications instances.
This tab lets you answer the following types of questions: Are all the Concurrent Managers up? Is there a backlog of pending requests? Which are the slow-running requests? How many requests fail?
Information on the Concurrent Managers includes their status, their availability, and the number of requests that are pending, running, or completed. Information on the Requests includes their status, priority, session details, requesting user and historical data on the program executed, and the programs arguments. All the information on the Concurrent Managers and Requests is based on data from the Oracle Applications tables in the Oracle database. To see information on interactive sessions, use the Current or Activity tabs. You can also see the database component of a request's run time performance in the Current or Activity tabs.
This section describes the available Oracle Applications parameters and how to use the tab. It does not, however, define the meaning of each Oracle Applications parameter or how to tune them; for this kind of information, see the appropriate Oracle documentation.
The Oracle Applications tab is only available if Interpoint for Oracle Applications has been installed. This is an optional extension to Precise for Oracle. For more information, see Installation and Administration. |
See Components of Precise for Oracle, About the Dashboard tab, About the Current tab, and About the Activity tab.
The Oracle Applications tab is divided into two views: Managers and Requests. Each view is also divided into two sections: the Main area on the left and the Details area on the right. Both areas can have additional tabs, depending on which view is selected.
The Time Frame selector that is available in other tabs is not present here because most of the information is current and other historical data is kept for a maximum of 14 days. In addition, the Instance selector lists only Oracle Applications instances in this application.
When the Requests tab is selected, additional Action controls are displayed: a Concurrent Manager selector and a Request type selector. The Concurrent Manager selector lets you choose a specific Concurrent Manager or All Managers. The currently selected Concurrent Manager is retained when you move between the Manager view and the Requests view. If, for example, you select the Standard Manager in the Manager view and then click Requests
, it will only display Requests submitted to the Standard Manager.
The Request Type selector lets you choose All Requests, Current Requests, Past Requests and so on. By default, all Requests are shown.
The Oracle Applications tab displays information on Concurrent Managers and Requests.
On the Mangers tab, the Main area displays a table that provides information on all Concurrent Managers. The following table describes the information displayed.
Table 1 Concurrent Manager information in the Main area
Column | Description |
---|---|
Indicates when the state of the Concurrent Manager is Stale . This column is empty for all other states. | |
Status | State of the Concurrent Manager, which can be Active , Running , Terminated , Inactive , or Stale . |
Concurrent Manager | Name of the Concurrent Manager. |
Pending Requests | Number of pending requests that are queued. |
Running Requests | Number of requests that are currently running. |
Running Processes | Number of Concurrent Manager processes that have been started. |
Available Processes | Number of Concurrent Manager processes that have not been started. |
The Details area shows specifics on the Concurrent Manager that is selected in the Main area. The information in this area is displayed on the Overview and the Processes tabs.
The Overview tab identifies the Concurrent Manager and gives general information about it. It also shows a graph of the number of pending and running requests over time. A request normally starts as Pending and changes later to Running, so it should contribute to both totals. If there is a backlog, the pending total will be greater than the running total for each time interval.
The Processes tab displays a table that provides details on the different processes. The following table describes the information displayed.
Table 2 Concurrent Manager table on the Processes tab
Column | Description |
---|---|
Indicates when the state of the process is Fault . This column is empty for all other states. | |
Process ID | Process ID of the Concurrent Manager process. |
Start At | Date the process was started. |
Oracle Process ID | Process ID of the Oracle server process. If the Concurrent Manager process is not connected and there is a fault, this column may provide extra information. |
In addition, this tab displays a History graph that illustrates the availability of the Concurrent Manager processes over time, as follows:
On the Requests tab, the information in the Main area is displayed on the Requests and the Arguments tabs. Both show a list of Requests filtered by the currently selected Oracle Applications instance, Concurrent Manager, and Request type. The difference lies in the columns that are displayed on each tab. The Requests tab provides the execution context; the Arguments tab shows the program that is executed, and its related arguments.
The following table describes the information displayed.
Table 3 Request information in the Main area
Column | Description |
---|---|
ID | Request ID. |
Program | Oracle Applications program that this Request executes. |
Manager | Requests tab only. Concurrent Manager handling this Request. |
User | Requests tab only. Oracle Applications user name. |
Phase | Requests tab only. Execution phase of the Request. The Request can be Inactive , Scheduled , Pending , Running , or Completed . |
Status | Requests tab only. Completion or success status of the Request. The Request can be Normal , Warning , Error , or Cancelled . |
Elapsed Time | Requests tab only. Time the request has spent in the Pending and Running states. |
Argument 1 to 5 | Argument to the Oracle Applications program. |
The Details area shows specifics on the Request that is selected in the Main area. The information is this area is displayed on the following tabs:
You can customize the time frame that is covered by the overtime graphs on the Managers and Requests tabs. See About configuring your settings.
To define the graph settings
You can identify a performance problem by doing one or more of the following:
The Concurrent Manager backlog shows us the number of requests (submitted to the Standard Manager) during a period of time. For our example, the Oracle Applications tab shows us that on Sept. 15, 33 requests were submitted to the Standard Manager in the first hour of September 15 and were therefore pending. Also 33 requests were run. In this case, even at the peak workload around midnight each day, it would appear that the Standard Manager processes were able to keep up with the workload. They at least ran the requests within an hour of being submitted.
To examine the Concurrent Manager backlog
Ideally, all Concurrent Manager processes should be available to do work.
To determine Concurrent Manager availability
The Oracle Applications tab shows the performance of related requests.
To examine requests
| | | | | | | |