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 table 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.
Right-click the header row in the Summary Details pane and select Column Chooser.
Add or remove attributes by dragging the column names to and from the Customization dialog. See ALL_TABLES in the Oracle Database Reference 11g Release 2 (11.2) for descriptions of table attributes.
Show or Hide Column Attributes
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:
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. |
Parse Execute Fetch Total | Displays the elapsed time for all parse, execute, and fetch calls, and the retrieval of any underlying views for a specific SQL statement. |
Trace CPU | Displays the total CPU time for all parse, execute, fetch calls, and the retrieval of any underlying views for a specific SQL statement. |
Trace Other | Displays the processing time not included in the total CPU time. |
Network | Displays the waiting time for data packets to traverse the network. |
I/O | Displays the waiting time to complete I/O tasks. |
Buffer |
Displays the waiting time for sufficient buffer cache space to become available. |
Lock |
Displays the status of a wait created when the current session must wait for the lock on a table or row to be released. |
Wait Total | Displays the remaining wait time for all locked items. |
Wait Other | Displays the remaining wait time for item other than the I/O wait, the Buffer wait, the Lock wait, and the Latch wait. |
Total Rows Processed | Displays the total number of rows processed by a specific SQL statement. |
Trace Physical Reads |
Displays the number of disk reads for parse, executions, and fetches. |
Trace Logical Reads |
Displays the number of logical data block reads including both memory and disk reads. |
Optimizer | Displays the overall approach that the optimizer takes to determine an execution plan. |
Cursor Misses | Displays the number of missed library caches during execute and fetch operations. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center