SQL Criteria Wizard (Classic)
Use the to select, retrieve and sort the SQL statements that are consuming the most system resources for the current connection.
Fields on the SQL Criteria Wizard (Classic) Dialog
Specify the SQL criteria to populate the Top SQL page.
| Field | Description |
|---|---|
|
Parsing user |
The username of the user who first parsed the SQL statement. (Other users may have executed the statement.) |
 |
Click Reset to reset the parsing user to (All users). |
|
Minimum executions |
The number of times the SQL statement has been executed. |
|
Minimum buffer gets |
The number of logical reads the SQL statement has invoked. |
|
Minimum disk reads |
The number of physical disk reads the SQL statement has invoked. |
|
Minimum rows |
The number of rows the SQL statement has retrieved. |
|
Contains |
A text string that the SQL statement must include. Only the first 1000 bytes of SQL statements are checked. |
|
Minimum buffer gets/execution |
The average number of buffer gets per execution. |
|
Minimum disk reads/execution |
The average number of disk reads per execution. |
|
Minimum rows/execution |
The average number of rows retrieved per execution. |
|
Sort by |
Select the sort order from the drop-down list. You can choose Ascending (for example, 1 to 99 or A to Z), or Descending (for example, 99 to 1 or Z to A). |
|
Maximum rows |
The maximum number of statements to retrieve For example, in an Oracle RAC cluster of three nodes with maximum rows = 100, the number of rows retrieved will be AT MOST 3 x 100 = 300 rows. |