Page History
...
The following table lists the work types available that are available per technology.
Table 3- 1 Work types per technology
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 Precise for Oracle tabs” on page 21, “About the Current tab” on page 51, “About the Activity tab” on page 61, “About the Objects tab” on page 87, “About the SQL tab” on page 131, “About the What-If tab” on page 159, “About the Statistics tab” on page 165, and “About the Oracle Applications tab” on page 178.
...
The following table shows the information displayed in the Instance table.
Table 3- 2 Instance table
Column | Description |
---|---|
Icon | Indicates whether or not the instance is available. |
Instance | Name of the instance. |
Server | Name of the server. |
In Oracle (Sum.) | Total In Oracle time of the instance within the selected time frame. |
Executions | Total statements executions within the selected time frame. |
Availability | Average percentage of time the instance was available within the selected time frame. |
Last Update | Time the instance availability status was last updated. |
Clustered | Indicates whether or not the instance belongs to a cluster. |
Database | Displays the Oracle database name for the instance. |
DB Name | Displays the Oracle database ID for the instance. |
Instances | Indicates how many instances share the same database with the instance. |
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. |
...
The following table describes the information displayed in the Instance Details area.
Table 3-3 Information displayed in the Instance Details area
Tab | Information Displayed |
---|---|
Overview | The Overview tab displays In Oracle data and performance findings for the selected instance, over the selected time period. |
Applications | The Applications tab displays the top resource-consuming programs, users and machines, for the selected instance, over the selected time period. |
RAC Database | Displays information related to the RAC database, such as top RAC events, top objects experiencing RAC wait, and a graph comparing the time spent by the selected instance In Oracle vs. the average time spent by all instances in the same RAC database. (if applicable) |
More | The following options are available in the More tab:
|
Info |
---|
If you select the All row, the information displayed reflects the average availability of all instances, and the Current tab is not available. |
...
The following table describes the entities displayed on the Overview tab.
Table 3- 4 General instance data
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. |
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
...
Oracle RAC allows two or more instances to simultaneously access a single database. This allows an application to connect to either computer and have access to the same data. Because all instances access the same database, it is essential that data changes on different computers are coordinated. The RAC Database tab displays activities related to the RAC database, such as top RAC events, top objects experiencing RAC wait, and a graph comparing the time spent by the selected instance In Oracle vs. the average time spent by all instances in the same RAC database. This lets you monitor the RAC activity in your system and check how well Oracle is synchronizing its buffer pool caches.
Table 3- 5 RAC Database tab display
Display | Description |
---|---|
In Oracle: Instance vs. All Instances in Same RAC database (Avg.) | Displays a graph comparing the time spent by the selected instance In Oracle vs. the average time spent by all instances In Oracle, in the same RAC database. This indicates whether or not the database is balanced. |
Top RAC Events | Displays the top RAC events experienced by the selected instance. Lets you compare the average amount of time spent by the top RAC wait events of all the instances in the RAC database to the amount of RAC wait time spent by the selected instance. |
Top Objects Experiencing RAC Wait | Displays the top objects experiencing RAC wait, sorted by how much they suffered from RAC wait. Lets you compare the average amount of time spent by the top objects of all the instances in the RAC database to the amount of RAC wait time spent by the objects of the selected instance. It also displays the object name and schema name of the object and indicates whether it is a table, index or cluster. The launch icon lets you launch directly to the Objects tab with the selected object in context, to continue your analysis. |
About top resource-consuming statements, objects, and files
...
All entities in this display launch the Activity tab, in context of an Oracle instance or Tier. The following table describes the information displayed in the Statement activities table.
Table 3- 6 Statement activities
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 36. 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. |
The following table describes the information displayed in the Object activities table.
Table 3- 7 Object activities
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 36. Click the respective icon to display the data in this column in a stacked graph, bar graph, or numerical format. |
The following table describes the information displayed in the File activities table.
Table 3- 8 File activities
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 “I/O wait” on page 38. Click on the respective icons to display the data in this column in a stacked graph, bar graph, or numerical format. |
About the session activity within the last minute
...
All items in this display launch the Current tab, in context of an Oracle instance or Tier. The following table describes the information displayed in the Session statistics table.
Table 3- 9 Session statistics
Counter | Description |
---|---|
Connected | Total number of sessions connected to the selected instance. |
Active | Total number of sessions currently active. |
Locked | Total number of locked sessions. |
The following table describes the information displayed in the Session activity table.
Table 3- 10 Session activity
Column | Description |
---|---|
Status icon | Indicates the current In Oracle sub-state. |
Session ID | The current session ID. |
Program | The name of the program that opened the session. |
Sub-State | A snap-shot of the current In Oracle sub-state of the session, as recorded by the Collector at the last sample point. |
In Oracle (Last Minute) | Total In Oracle time for the session occurring within the last minute, broken down into the different In Oracle wait states. |
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.
...
- 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.
Precise. Performance intelligence from click to storage. Learn more > >
...