Page History
...
| Technology | Work Type |
|---|---|
| Oracle Applications | Can be any of the following:
|
| SAP | Can be any of the following:
|
| PeopleSoft | Can be any of the following:
|
| Siebel | Can be any of the following:
|
See “About About Precise for Oracle tabs” on page 21, “About tabs, About the Current tab” on page 51, “About tab, About the Activity tab” on page 61, “About tab, About the Objects tab” on page 87, “About tab, About the SQL tab” on page 131, “About tab, About the What-If tab” on page 159, “About tab, About the Statistics tab” on page 165tab, and “About About the Oracle Applications tab” on page 178tab.
| Anchor | ||||
|---|---|---|---|---|
|
The Dashboard tab is divided into two areas the Main area and the Instance Details area. The Main area lists all the instances that are monitored by Precise for Oracle. The Instance Details area provides comparative information regarding the selected instance. You can filter the information shown in the Instance Details area so that only the contribution of certain entities is included. See “Filtering data” on page 29 Filtering data.
About the Main area in the Dashboard tab
...
| Info |
|---|
When you open the Dashboard tab, only the first few columns are displayed. To view additional columns (such as: Executions and Last Update columns), use the scroll bar at the bottom of the screen. |
See “Determining Determining which table columns to display” on page 33display.
About the Instance Details area in the Dashboard tab
...
| General instance data | Description |
|---|---|
| In Oracle | Displays the total time spent In Oracle over time, broken down into the different In Oracle wait states, such as Using CPU, I/O Wait, Application Lock Wait, and so on. See “In Oracle” on page 36 Wait stats - In Oracle. |
| Findings | Displays top performance findings. All problems are ranked by severity and lets you launch the finding, in context, to the appropriate tab. The information is displayed in the findings table. |
| Availability | Displays the Availability SLA (as defined in AdminPoint) vs. the actual availability over time. See the Precise Administration Guide. |
About top resource-consuming entities
...
All entities in this display launch the Activity tab, in context of the Oracle instance.
See “Precise Precise Interpoint - how resource consumption of packaged applications is examined” on page 40examined.
About RAC database activity
...
| Column | Description |
|---|---|
| Statement | Statement name. This is either a numeric hash value or a user-defined name. |
| In Oracle (Sum.) | Total In Oracle time of the statement, broken down into the different In Oracle wait states. See “In Oracle” on page 36Wait stats - In Oracle. Click the respective icon to display the data in this column in a stacked graph, bar graph, or numerical format. |
| Executions | Number of executions of the statement. |
...
| Column | Description |
|---|---|
| Object | Name of the object. |
| Type | Type of the object, typically a table or index. |
| In Oracle (Sum.) | Total In Oracle time of the object, broken down into the In Oracle wait states relevant to Objects. See “In Oracle” on page 36Wait stats - In Oracle. Click the respective icon to display the data in this column in a stacked graph, bar graph, or numerical format. |
...
| Column | Description |
|---|---|
| Oracle File | Path and name of the Oracle file. |
| I/O Wait | Total I/O wait time of the file, broken down into I/O wait states relevant to files. See “II/O wait” on page 38wait. Click on the respective icons to display the data in this column in a stacked graph, bar graph, or numerical format. |
...
In addition, two pie charts summarize the overall activity and the In Oracle activity that occurred within the last minute, broken down into Overall Activity states and In Oracle wait states, respectively. See “Overall activity” on page 35 and “In Oracle” on page 36 Overall activity and Wait stats - In Oracle.
About the availability of an instance
...
For more information about identifying performance problems in the Dashboard tab, see “How How the Dashboard tab can help you identify performance problems” on page 48problems.
| Anchor | ||||
|---|---|---|---|---|
|
...
For more information, see the Precise Administration Guide. and See “How How Precise for Oracle monitors availability” on page 35availability.
The following example shows how to examine the availability of an Oracle instance, observe its current status, and its availability over time.
...
- In the Instance list, choose the instance you want to analyze.
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance Details area, click Applications. For example, a SAP database, PS8 on hp8, is monitored by Interpoint for SAP.
The Application tab shows the following SAP-related top entities:- Background work type
- SAP user SUPER
- Transaction SAP_CCMS_MONI_BATCH_DP Most likely, these entities are related.
- To investigate further, click an entity to launch the Activity tab. In the Activity tab you can confirm the connection between the problematic entities. For this example, you can identify a background SAP transaction run by the SAP CCMS administration tool.