Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

SQL Statistics Page

To open the SQL Statistics page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.

  2. Click SQL & Application Workload | Top SQL Page.

  3. Select a SQL Statement in the Top SQL grid.
  4. Click Statistics.

Note: Click Full screen for an expanded view of SQL Details. SQL Details (Full Screen) Page

SQL Statistics

Data Description


The number of times the SQL statement has been executed.


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.


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.


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.



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.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating