Versions Compared

Key

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

...

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.

...

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 the Precise Installation Guideand Administration.

See “Components Components of Precise for Oracle” on page 17, “About Oracle, About the Dashboard tab” on page 43, “About tab, About the Current tab” on page 51tab, and “About About the Activity tab” on page 61tab.

Anchor
HowtheOracleApplicationstabisstructured
HowtheOracleApplicationstabisstructured
How the Oracle Applications tab is structured

...

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

ColumnDescription
Image Modified
Indicates when the state of the Concurrent Manager is Stale. This column is empty for all other states.
StatusState 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.

...

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

Table 11- 2 Concurrent Manager table on the Processes tab

ColumnDescription
Image Modified
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 or not.

Viewing information about Requests

...

The following table describes the information displayed.

Table 11- 3 Request information in the Main area

ColumnDescription
IDRequest ID.
ProgramOracle Applications program that this Request executes.
ManagerRequests tab only. Concurrent Manager handling this Request.
UserRequests 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:

...

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 Settings>General Settings > General Settings.
  2. Specify for how many days you want to view the Concurrent Manager history.
  3. Specify for how many hours you want to view the Concurrent Manager request history.
  4. Click OK.

...

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

  1. In the Time Frame list, choose the period of time you want to analyze.
  2. 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
 

...

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

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
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

...