Page History
...
- When clicking the Recommend link in the Finding on the Activity tab the following message will appear:
Unable to perform the
...
Recommended function. Verify that the Oracle Advisor is enabled in the Precise registry.
To disable the Oracle Advisor1 For
- For each instance, open the
<SID_name>.xmlfile in the following location:\products\i3fp\registry\products\indepth-oracle\hosts\
...
<host_
...
name>\oracle
...
- Under the <recommend> tag, add/edit the following tag:
<oem-enabled>N</oem-enabled>
WhereNdisables the Oracle Advisor.
...
- Save the
<SID_name>.xmlfile.
...
- Restart the Precise for Oracle FocalPoint.
About the Run Alternatives view
The Run Alternatives view lets you run different statement alternatives under different conditions (bind variables and session parameters) and view details on how the statement was run.
...
Table 8-8 Alternative Statements
Column Description
...
| Column | Description |
|---|---|
 | Launches to the Plan view with the statement in context and lets you view the statement's execution plan, in the Highlights tab. |
...
 | Lets you compare the alternative statement with the original statement. |
...
| Status | Displays whether or not the statement was successfully run, or whether it is still running or has timed out. |
...
| Name | The information displays for the following statement names: |
...
|
...
|
...
|
...
| Timestamp | Displays the time the statement was run. |
| Plan Hash |
...
| Value | Displays the hash value for the plan associated with the selected statement. |
| Statement |
...
| ID | Displays the statement ID. |
| Duration (Avg.) |
...
| Displays how long the statement ran. | |
| Cost |
...
| Displays the average cost of the plan. |
| Logical I/O (Avg.) |
...
| Displays the average number of logical I/O operations per executed statement. | |
| Physical |
...
| Reads | Number of physical reads from disk. |
| Hit |
...
| Ratio | Number of physical reads or logical reads, expressed as a percentage. |
| Table |
...
| Scans | Number of full table scans performed. |
| Write |
...
| Requests | Number of requests to write data to disk, usually of temporary data during joins and sorts. |
| Sorts |
...
| Number of sorts performed. |
| Sorted |
...
| Rows | Total number of sorted rows. |
| Table Scans by Row |
...
| ID | Number of accesses to a table by Row ID. A Row ID contains the address of a row in a table and is the fastest way to gain access to an individual row, although not necessarily to multiple rows. Access via Row ID usually follows an index scan, because Row IDs are stored in the leaf blocks of an index. |
| Table Scan Rows |
...
| Gotten | Number of rows retrieved from tables. |
| Table Scan |
...
| Blocks | Number of blocks fetched from tables. |
| Recursive |
...
| Calls | Number of recursive SQL calls that Oracle made to the data dictionary while executing the statement. |
| Processed |
...
| Rows | Number of rows processed during the execution. This includes rows retrieved from tables, indexes, and temporary segments. It may be many more than are returned. |
| Host |
...
| Name | Displays the host name of the server that the statement is running on. |
Description |
...
| If you chose to run an alternative of the statement, this field displays the description assigned to the run in the Run Statement dialog box. |
| Attempted |
...
| Executions | Number of executions started. |
| Actual |
...
| Executions | Number of executions completed. |
About the text of an alternative statement
This view displays the text associated with the alternative statement.
About the plan tree of an alternative statement
This view displays the plan associated with the alternative statement, or the original statement.
About the Run Info view
The Run Info view displays bind variables and session parameters used during the run of the selected alternative statement.
About the Extended Statistics view
The Extended Statistics view displays additional statistics on the alternative runs.
...