SQL Statistics Page
To open the SQL Statistics page
-
Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Top SQL Page.
- Select a SQL Statement in the Top SQL grid.
- Click Statistics.
Note: Click Full screen for an expanded view of SQL Details. SQL Details (Full Screen) Page
SQL Statistics
| Data | Description |
|---|---|
|
Executions |
The number of times the SQL statement has been executed. |
|
Rows |
The total number of rows retrieved by the SQL statement. |
|
Buffer Gets |
The total number of logical reads (buffer gets) retrieved by the SQL statement. |
|
Disk Reads |
The total number of physical disk reads recorded against the SQL statement. |
|
Sorts |
The total number of sort operations recorded against the SQL statement. |
|
Rows / Execution |
The average number of rows retrieved per execution. |
|
Buffer Gets / Execution |
The average number of buffer gets per execution. |
|
Disk Reads / Execution |
The average number of disk reads per execution. |
|
Sorts /Execution |
The average number of sorts per execution. |
|
Buffer Gets / Row |
The average number of buffer gets per row retrieved. |
|
Disk Reads / Row |
The average number of disk reads per row retrieved. |
|
Sorts / Row |
The average number of sorts per row retrieved. |
|
Address |
The address of the cursor that contains the SQL statement. |
|
Hash Value |
The hash value for the SQL statement in the library cache. |
|
Optimizer Mode |
The mode under which the SQL statement was executed. |
|
Optimizer Cost |
The cost of executing the SQL statement (via the cost-based optimizer). |
|
Hit Rate |
How often reads have been executed via logical reads (buffer gets) as a percentage of total reads (buffer gets plus disk reads). |
SQL Text
The full text of the SQL statement being executed.
|
Action |
Description |
|---|---|
Click Explain SQL  |
Explain the SQL via the Explain Plan. Tools | Explain Plan |
Click SQL Optimizer  |
Display context-sensitive tuning advice for SQL statements via SQL Optimizer (or SQL Tuning). Tools | SQL Optimizer Note: For more information on SQL Optimizer, see the SQL Optimizer documentation. |
Click Predictive Diagnostics  |
Will the selected SQL statement scale adequately as data volumes and SQL execution rates increase? View Spotlight's Predictive Diagnostics analysis. SQL Performance |
| Right-click the SQL Text window and select Format SQL. | Display the SQL statement in a more readable form. |
Note: If the SQL cannot be explained, the Explain Plan and SQL Optimizer (SQL Tuning) options may be unavailable.