Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section includes the following topics:

 

...

 

...

 

...

 

...

 

...

Anchor

...

AbouttheOracleApplicationstab

...

AbouttheOracleApplicationstab
About the Oracle Applications tab

...

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. 

Info

 

...

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 Components of Precise for Oracle” on page 17. See the Precise Installation Guide.

See “About the Dashboard tab” on page 43. See “About the Current tab” on page 51. See “About the Activity tab” on page 61.

 

...

Oracle, About the Dashboard tab, About the Current tab, and About the Activity tab.

Anchor
HowtheOracleApplicationstabisstructured
HowtheOracleApplicationstabisstructured
How the Oracle Applications tab is structured

...

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.

...

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. 

Anchor
AbouttheinformationyoucanexamineintheOracleApplicationstab

...

AbouttheinformationyoucanexamineintheOracleApplicationstab
About the information you can examine in the Oracle

...

Applications tab

...

The Oracle Applications tab displays information on Concurrent Managers and Requests. 

 

Viewing information about Concurrent Managers

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 11-1    Concurrent 1 Concurrent Manager information in the Main area 

Column

...

Description

...

Image Added

...

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

...

ManagerName of the Concurrent Manager.
Pending

...

RequestsNumber of pending requests that are queued.
Running

...

RequestsNumber of requests that are currently running.
Running

...

ProcessesNumber of Concurrent Manager processes that have been started.
Available

...

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

About the overview of Concurrent Managers

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.

 

 

About Concurrent Manager processes

The Processes tab displays a table that provides details on the different processes. The following table describes the information displayed.

Table 11-2    Concurrent 2 Concurrent Manager table on the Processes tab

 

Column    Description

...

ColumnDescription
Image Added
Indicates when the state of the process is Fault. This column is empty for all other states.
Process IDProcess

...

ID of the Concurrent Manager process.
Start

...

AtDate the process was started.
Oracle Process IDProcess

...

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:

 

...

  • Processes Target. The total number of Concurrent Manager processes on a particular day.

 

...

  • Processes Target OK and Processes Target

...

  • Missed. Represent the average number of running processes on that day and whether the target was hit

...

  • .

...

Viewing information about Requests

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 11-3    Request Table 3 Request information in the Main area

Column

...

Description

...

ID

...

Request ID.
Program

...

Oracle Applications program that this Request executes.

...

ManagerRequests tab only. Concurrent Manager handling this Request.
User

...

Requests tab only. Oracle Applications user name.

...

PhaseRequests tab only. Execution phase of the Request. The Request can be Inactive, Scheduled, Pending, Running, or Completed.

...

StatusRequests tab only. Completion or success status of the Request. The Request can be Normal, Warning, Error, or Cancelled.
Elapsed

...

TimeRequests tab only. Time the request has spent in the Pending and Running states.
Argument 1 to

...

5Argument 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:

 

...

  • Overview. Shows the status of the Request, its identification details, and its executed program details.

 

...

  • Last 14 Day

...

 

...

  • History. Displays the following pie charts:

...

    • Total Time (Same program, various arguments)

...

 

    • . Proportion of time that all Requests with the same program name as this Request have spent either pending or running during the last 14 days.

 

 

 

 

    • Total Time (Same program, same arguments)

...

 

    • . Proportion of time that all Requests with the same program name and arguments as this

...

    • Request have spent either pending or running during the last 14 days.

...

 

...

    • Completions (Same program, various arguments)

...

 

 

    • . Proportion of successful and unsuccessful executions of all programs with the same name as this Request during the last 14 days. It also displays general information about the

...

    • executed program.

 

 

 

    • Completions (Same program, same arguments)

...

 

    • . Proportion of successful and unsuccessful executions of all programs with the same name and arguments as this Request during the last 14 days. It also displays general information about the executed program.

 

 

...

  • Details. More specifics on the request, such as whether it has a sub-request, its completion code, its schedule, and its output destination.

...

Anchor
Definingthesettingsofovertimegraphs

...

Definingthesettingsofovertimegraphs
Defining the settings of overtime graphs

...

You can customize the time frame that is covered by the overtime graphs on the Managers and Requests tabs. See “About About configuring your settings” on page 26settings.

To define the graph settings

 

...

  1. On the Precise toolbar, click

...

  1. Settings > General Settings.

 

...

  1. Specify for how many days you want to view the Concurrent Manager history.

 

...

  1. Specify for how many hours you want to view the Concurrent Manager request history.

 

...

  1. Click OK.

Anchor

...

HowtheOracleApplicationstabcanhelpyouidentifyperformanceproblems

...

HowtheOracleApplicationstabcanhelpyouidentifyperformanceproblems
How the Oracle Applications tab can help you identify performance problems

...

You can identify a performance problem by doing one or more of the following:

 

...

 

...

 

■    Examining requests

 

...

Anchor
ExaminingConcurrentManagerbacklog
ExaminingConcurrentManagerbacklog
Examining Concurrent Manager backlog

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

 

...

  1. In the Time Frame list, choose the period of time you want to analyze.

 

...

  1. Open the Oracle Applications tab to view the number of submitted requests.

Anchor

...

DeterminingConcurrentManageravailability

...

DeterminingConcurrentManageravailability
Determining Concurrent Manager availability

Ideally, all Concurrent Manager processes should be available to do work.

To determine Concurrent Manager availability1    In

  1. In the Time Frame list, choose the period of time you want to analyze.

 

...

  1. Open the Oracle Applications tab to view the number of available processes.

 

 

...

  1. Click the Processes tab. Examining the Processes tab, for the Standard Manager, shows that the number of available processes has not always hit the target figure. On September 15, the average number of processes available was 7.21 out of 16. Looking at the current state of the processes identifies that they cannot connect to Oracle, perhaps because it is unavailable.

Anchor
Examiningrequests

...

Examiningrequests
Examining requests

The Oracle Applications tab shows the performance of related requests.

To examine requests1    In

  1. In the Time Frame list, choose the period of time you want to analyze.

 

...

  1. Open the Oracle Applications tab to view the number of submitted requests.
    In the Main area, for our example, we see that Request 2160224 completed normally. The Details area displays the past performance of related requests.
    The top two pie charts reveal that related requests spent approximately twice as long executing as they did waiting to be executed, regardless of which arguments were passed. The bottom two pie charts show the proportion of successful to unsuccessful executions.
    The program has exited with an error code on 3 occasions, but has always been successful when executed with exactly the same arguments as the selected request. In other words, it has only failed when passing different arguments to the current request


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
| 

...

Precise. Performance intelligence from click to storage. Learn more > >

...

Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...