SQL Statements Page
SQL Statements Page
The SQL Statements page lists all the SQL statements within the trace file selected in the Trace Files Page.
To open the SQL Statements page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Analyze Trace | Trace Files.
-
Select a Trace File.
If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog
Click SQL Statements
SQL Statements Grid
Click a row to open SQL Statement Information.
Double-click the row to open the SQL Statement Details Page for the statement.
Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns
| Column | Description |
|---|---|
|
SQL ID |
The number allocated to the specified SQL statement within the trace file. |
|
Elapsed (ms) |
The total server execution time for the SQL statement (parse, execute and fetch). |
|
CPU (ms) |
The CPU time spent executing the SQL statement. |
|
Fetch Count |
The number of fetches performed for the SQL statement. |
|
Parse Count |
The number of parses performed for the SQL statement. |
|
Logical IO |
The number of logical I/O operations for the SQL statement. |
|
Total Rows |
The total number of rows processed for the SQL statement. |
|
Disk IO |
The number of disk I/O operations for the SQL statement. |
|
Execute Count |
The number of times the SQL statement was executed. |
|
% Total Elapsed |
The percentage of the total elapsed time spent executing the SQL statement. |
|
Logical IO/Exec |
The average number of logical I/O operations performed each time the SQL statement was executed. |
|
Logical IO/Row |
The average number of logical I/O operations performed for each row processed by the SQL statement. |
|
CPU/Exec |
The average number of CPU operations performed each time the SQL statement was executed. |
|
Disk/Exec |
The average number of disk I/O operations performed each time the SQL statement was executed. |
|
SQL Statement |
The text of the SQL statement. |
|
Address |
The address where data has been returned by the SQL statement. |
|
Formatted SQL |
The text of the SQL statement formatted for readability. |
|
Hash Value |
The hash value for the SQL statement in the library cache. |
SQL Statement Information shows the following information about the selected SQL statement. More information on the selected SQL statement is available from the SQL Statement Details Page.
|
Section |
Description |
|---|---|
| SQL Text | The full text of the selected SQL statement. |
| SQL Statistics |
The SQL Statistics table displays statistical information about the selected SQL statement.
|