Page History
...
The Overall Activity view displays a stacked bar graph on the Overall Activity resource consumption over time, for the selected time frame, broken down into the Overall Activity wait states. See “Overall activity” on page 35 Overall activity.
About the scalability view
...
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 “Oracle Oracle statistics usage within Precise for Oracle” on page 40Oracle.
About the RAC database view
...
If bind variables were captured for a statement, a link is displayed that launches to the Bind Variables tab in the SQL tab, with the statement in context, to run a statement with the actual bind variables that are being used. If you drill down to a statement from an execution plan entity, and execution plans were captured for the statement, a link is displayed that launches to the All Plans tab in the SQL tab, with the statement in context. See Wait States - In Oracle and “About About the Bind Variables view” on page 148view.
The following table explains how the general information is structured.
...
| 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 Executions vs. opens and fetches” on page 39fetches. |
| 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 of fetch 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 Overall Activity view, in the Activity tab, displays a stacked bar graph on the overall activity resource consumption over time, for the selected time frame, broken down into overall activity wait states. See “Overall activity” on page 35See Overall activity.
About the scalability of a statement or PL/SQL
...
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 “Oracle See Oracle statistics usage within Precise for Oracle” on page 40Oracle.
About the text view of a statement or PL/SQL
...
See Editing the properties of a statement and “About and About the SQL tab” on page 131tab.
About the Execution Plan entity
...
The Overall Activity view, in the Activity tab, displays a stacked bar graph describing the overall activity resource consumption of the execution plan over time, broken down into overall activity wait states. See “Overall activity” on page 35See Overall activity.
About the scalability view of an execution plan
...
The Overall Activity view, in the Activity tab, displays a stacked bar graph on the Overall Activity resource consumption over time, for the selected time frame, broken down into the Overall Activity wait states. See “Overall activity” on page 35See Overall activity.
About Session and Recent Session entities (in Table view only)
...
The Overall Activity view, in the Activity tab, displays a stacked bar graph on the Overall Activity resource consumption over time, for the selected time frame, broken down into the Overall Activity wait states. See “Overall activity” on page 35See Overall activity.
About the Imported Statement entity
...
See Editing the properties of a statement and “About and About the SQL tab” on page 131tab.
About storage device entities
...