SQL Optimizer for Oracle 10.0

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.

Related Topics

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To show or hide an index 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 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.

Related Topics

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.
To remove an attribute, drag it from the pane back to the Customization dialog.

For a description of each column attribute, please refer to the Oracle Database documentation:

Related Topics

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To view statistics information

Click the following to view information for each statistic type.

Related Topics

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.

SQL Optimizer for Oracle 10.0 - User Guide