Page History
...
Table 8-6 Execution plan statistics
Column Description
...
| Column | Description |
|---|---|
 | Locates and highlights the step in the Execution Plan tree that matches the selected step in the grid. |
| Step |
...
| ID | Displays the number of the explain plan step. |
...
| Step | Provides a short description of the explain plan step. |
| Estimated Cost | Estimated |
...
| cost of the current operation. A high cost value may indicate a problem in the current implementation of the operation. Check the Estimated I/O cost and Estimated CPU cost values to determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both). |
| Estimated |
...
| Rows | Estimated number of rows returned by this step. |
| Estimated Bytes | Estimated |
...
| number of bytes returned by this step. |
| Estimated CPU |
...
| Cost | The estimated CPU cost of the current operation. A high cost value may indicate a problem in the current implementation of the operation. |
| Estimated I/O |
...
| Cost | Estimated I/O cost of the current operation. A high cost value may indicate a problem in the current implementation of the operation. |
...
| Partitioned ID | Name |
...
| of the table or index partition, if the step involves a partitioned table or index. |
| Partition |
...
| Start | Low value of the partition key. |
...
| Partitioned Stop | High |
...
| value of the partition key. |
| Access |
...
| Predicates | Predicates used to locate rows in an access structure; for example start or stop predicates for an index range scan (as defined in Oracle documentation). |
| Filter |
...
| Predicates | Predicates used to filter rows before producing them (as defined in Oracle documentation). |
...
| # | Step #. |
| In Oracle | In |
...
| Oracle time for the specific step. |
...
| Cost | Cost for the specific step. |
| Other |
...
| Tag | Data as seen in Oracle for specific step. |
| Plan |
...
| Hash | Plan hash value. |
About information on statement plan, location, and text
The Workshop tab displays details on the execution plan, where the statement is stored, and the SQL text of the statement.
...
Table 8-7 Structure of information on the Workshop tab
| Item |
|---|
...
| Description |
|---|
| Explained |
...
| on | Date the latest explain plan was first generated. |
...
| Cost | Estimated cost calculated by the Oracle cost-based Optimizer. |
| Parsing |
...
| User | In the case of an imported or manually saved statement, this is the Oracle user that was specified at the time; in the case of an automatically captured statement, it is the first Oracle user that the Precise for Oracle Collector found running the statement. |
...
| Cabinet | Cabinet where the statement is stored. |
| Folder |
...
| Folder within the cabinet where the statement is stored. |
| Origin |
...
Source of the statement. The Precise for Oracle Collector will automatically capture most statements when they are executing in Oracle, but some may be imported from source files or saved manually. Possible values are: |
...
|
...
|
...
|
...
|
...
|
...
|
| Saved |
...
| on | Date that the statement was saved. |
| Parsing |
...
| Information | Indicates whether Precise for Oracle has performed an extra level of parsing above that performed by Oracle to support more detailed analysis and syntax color highlighting. |
...
| Comment | User-defined comment that can be entered against a statement when it is saved. |
...
| See “Editing the properties of a statement” on page 31. |
About the Recommend button
The Recommend button above the right pane is used to activate the Oracle Advisor (default) or Precise Advisor. The result of the recommendation is shown in the What-If Tier.
We recommend you to use the Oracle Advisor, as this provides an extended Oracle functionality. The recommendation van be evaluated by the What-If analysis.Note:
| Info |
|---|
The Precise Advisor on the SQL tab will be used instead of the Oracle Advisor when: the Oracle Advisor is not installed, the Oracle version does not support it, or the usage of the Oracle Advisor was manually disabled in our application (for more information on how to manually disable the default Oracle Advisor, see “Disabling the Oracle Advisor” on page 139. |
Disabling the Oracle Advisor
When you decide to disable the Oracle Advisor, you have to make changes in the registry file per instance. The result will be that the Precise Advisor will be used with the following limitation:
...