To show or hide an index attribute
Select the Optimize SQL tab in the main window.
Select a SQL Rewrite or Plan Control Session.
Click beside the Summary list and select a table.
Right-click the header row of the Index Attributes pane and select Column Chooser.
Note: The Index Attributes pane is the first pane in the Schema Information tab.
Add or remove attributes by dragging the column names to and from the Customization dialog. See ALL_INDEXES in Oracle Database Reference 11g Release 2 (11.2) for descriptions of index attributes.
Show or Hide Column Attributes
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To show or hide a column attribute
Select the Optimize SQL tab in the main window.
Select a SQL Rewrite or Plan Control Session.
Select the Schema Information tab in the Optimize SQL window.
Click beside the Summary list and select a table.
Right-click the header row of the Column Attributes pane and select Column Chooser. The Customization dialog opens.
Note: The Column Attributes pane is the lower pane in the Schema Information tab.
To add an attribute to the pane, drag the attribute name to the pane from the Customization dialog.
For a description of each column attribute, please refer to the Oracle Database documentation:
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view statistics information
Select the Statistics Information tab in the Optimize SQL window.
Click the following to view information for each statistic type.
Elapsed Time | Displays the execution time to retrieve the entire result set. |
First Row Time | Displays the execution time to retrieve the first row of the SQL statement. |
Number of Records | Displays the number of records retrieved or processed by the SQL statement. |
Status | Displays client status. |
Physical Reads |
Displays the number of disk reads for parses, execution, and fetches. |
Session Logical Reads |
Displays the number of logical data block reads, including both memory reads and disk reads. |
CPU Used by this Session |
Displays the total CPU time used for this session. |
Parse Time CPU |
Displays the total CPU time used to parse the statement. |
Parse Time Elapsed |
Displays the time used to parse the statement. |
Sorts (Memory) |
Displays the number of sort operations performed to execute the SQL statement. |
Sorts (Disk) |
Displays the number of temporary segments used to execute the SQL statement. |
Sorts (Rows) |
Displays the number of rows sorted during execution of the SQL statement. |
Table Fetch by ROWID |
Displays the number of rows accessed by ROWID. |
Table Scan Blocks Gotten |
Displays the number of blocks accessed when scanning a table. |
Table Fetch Continued Row |
Displays the number of rows accessed that span multiple blocks. |
Table Scan Rows Gotten |
Displays the number of rows accessed by a full table scan. |
Table Scans (Short Tables) |
Displays the number of scans from sort tables. |
Table Scans (Long Tables) |
Displays the number of scans that are not short scans. |
Consistent Changes |
Displays the number of times a consistent get rolled back changes resulting from cursor access. |
Consistent Gets |
Displays the number of consistent reads performed during data retrieval. |
View Schema Information (Plan Control)
Use the Compare window to view the execution plan and execution statistics for your original SQL statement and all alternatives SQL Optimizer generates. The Compare window consists of the Alternatives window and the Comparison window. The Alternatives window displays execution statistics and the Comparison window displays execution plans. You can compare the execution plan of your original SQL statement with an alternative SQL Optimizer generates or compare execution plans for two different alternatives.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To compare execution plan alternatives
Select a Plan Control session.
Click .
Select an alternative in the Plans pane to compare the alternative plan with your original execution plan.
Note: The Comparison window displays the original execution plan in both panes by default.
Tip: The alternative you selected is shown under your original SQL statement in the Alternatives window by default. To unfreeze the alternative selected, right-click the alternative and select Unfreeze Comparing Rows
Click to switch the location of the original execution plan and selected alternative in the Comparison pane.
Note: Switch the location of the original execution plan to compare two alternatives. Once you select the first alternative, click and select the second alternative.
Click the current layout option in the Comparison pane to change the layout for the statements.
Review the following for additional information:
Plan only (Left-Right) | Displays the execution plans side by side. |
SQL and Plan (Left-Right) | Displays the SQL text for your original statement and the execution plans side by side. |
Plan only (Top-Bottom) | Displays the execution plans beneath each other. |
SQL and Plan (Top-Bottom) | Displays the SQL text for your original statement and the execution plans beneath each other. |
Tip: Click to maximize the Comparison pane. You can click to restore the Comparison pane to its original size. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center