To open the SQL Statistics page
Select the Spotlight on Oracle connection in the Spotlight Browser.
Click SQL & Application Workload | Top SQL Page.
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center