Page History
...
You can switch to a different time frame and view additional information on the selected entity that was collected for that time frame. Only the information in the subnodes sub-nodes of the entity you have selected is refreshed.
...
The Refresh option refreshes the display from the PMDB.
To refresh the information displayed in a view
...
You can print an image of what is displayed in the Tree view.
To print the Tree View display
...
| Graph | Description |
|---|---|
| Availability | Compares the overall availability with the Availability SLA, in percent. The settings for the Availability SLA are defined in AdminPoint. For more information, see the Precise Administration Guide. Availability information is also displayed on the Overview tab in the Dashboard tab. |
| Unavailability Times | Indicates the amount of time that the instance or instances were unavailable. |
...
The Statistics view displays a table that indicates a change in Oracle statistics for the selected entity during the specified time frame. The Statistics column displays statistics that represent different counters with different units. For more information, see the Oracle documentation . See and Oracle statistics usage within Precise for Oracle.
...
| Item | Description |
|---|---|
| Database | Displays the logical name of the RAC database. |
| DB Name | Displays the Oracle database ID for the instance. |
| DB ID | Displays the Oracle database ID. |
| In Oracle (Sum.) | Total time the instance spent In Oracle. |
| Sessions | Total number of active sessions associated with the instance. An active session is one that executed or was executing a statement during the selected time frame and spent some time In Oracle. |
| Executions Counts | Number of executions. |
| In Oracle (Avg.) | Average In Oracle time for all instances in the RAC database. |
| Instances | Displays the number of instances that share the same RAC database with the selected instance. |
| In Oracle (Avg. per instance) | Average In Oracle time for the selected instance. |
| RAC Database table | Shows additional details on the instances in the RAC database, such as the number of sessions run by each instance, the amount of time each spent actively executing statements and PL/SQLs within Oracle, and the number of statements executed by each instance. |
...
| Item | Description |
|---|---|
| In Oracle (Sum.) | Total time the statement or PL/SQL spent In Oracle. |
| Executions/Execution Counts | Number of times the statement or PL/SQL was executed. See Executions vs. opens and fetches. |
| In Oracle (Avg.) | For a statement only. Total In Oracle time for the statement or number of executions. If Opens + Fetches are displayed, this field displays N/A. |
| Duration (Avg.) | For a statement only. Total overall activity time for the statement or the number of executions. |
| Buffer Gets (Avg.) | For a statement only. Total number of buffer gets for the statement or the number of executions. If Opens + Fetches are displayed, this field displays N/A. |
| Rows Processed (Avg.) | For a statement only. Total number of rows processed by the statement or the number of executions. If Opens + Fetches are displayed, this field displays N/A. |
| Parallel Servers (Min.) | Minimum number of parallel query slaves that executed the statement. |
| Parallel Servers (Max.) | Maximum number of parallel query slaves that executed the statement. |
| End of Fetch Count | Number of times the statement returned all rows to the user rather than returning only the first rows and dropping the cursor. “End End of fetch count” count will always be less than or equal to executions. |
| Version Count (Max.) | Shows the maximum number of cursors created for the particular statement in parallel. |
...
The Statistics view, in the Activity tab, displays a table indicating a change in Oracle statistics for the selected statement or SQL during the specified time frame. The Statistics column displays statistics representing different counters with different units. For more information, see the Oracle documentation . See and Oracle statistics usage within Precise for Oracle.
...
In addition, Precise for Oracle keeps the last n hours of session information on the server and makes it available using Recent Sessions. By default, information for the last 4 four hours is saved. You can specify and change the length of time using Precise Agent Installer (see the Precise Installation Guide for detailssee Installation and Administration), but increasing it will obviously require more storage.
...
Statements can be imported from external source files into Precise for Oracle and stored in the cabinet and folder hierarchy. To display them in the Activity tab, use the More... option option in the Association area and click Imported Statements.
...
| Info |
|---|
These entities are only available if you have installed Precise for Storage. For more information on the supported platforms, see the Precise Installation Guideand Administration. |
The Activity tab offers a unique method for identifying I/O problems in EMC and HP storage devices. It reports I/O wait time instead of just I/O counters. This lets you easily identify the resource that is actually being waited for and tune it instead of guessing by rules of thumb. Furthermore, you can associate the storage device with the applications and statements that are waiting on I/O.
...
Using the Define Extended Collection dialog box, you can specify the instance that you want to monitor, the name of your collection, the start and stop time, and the maximum size of the trace. You then use the entity table to define the entities that you want to include or exclude. In the Include and Exclude fields, you can use the Oracle SQL-style wildcards ‘'-’ ' and ‘%’ '%' to match zero or more characters and ‘'_’ ' to match a single character. The AND operator is used to produce the final selection.
...
If duplicates are detected during the import process, the newer version of a statement will not over-ride override the older version.
To define Source tab details
...
You can display the average duration for statements with the format shown as hh:mm:ss.
The following example shows how to drill down to application components and identify resource consumers. For our example, the Active tab shows a list of programs that you can drill down to in the Tree pane. We want to drill down to the program that spent the most time.
...
Precise for Storage, Oracle version, supports EMC devices and lets you see the resource consumption of the EMC Storage devices from the application’s application's point of view.
The following example shows how to examine EMC Storage devices resource consumption. To examine EMC Storage devices
...