Page History
...
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.