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 Details Page

The SQL Details page displays extra information about the SQL statement selected in the Top SQL table.

To open the SQL Details page

  1. Select the Spotlight on Oracle RAC 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 SQL Details.

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

SQL Details

Data Description


The SQL identifier for the specified SQL statement in the library cache.


The address of the cursor that contains the SQL statement.

First Load Time

The first time the SQL statement was loaded.

Last Active Time

The last time the query plan for the SQL statement was active.

Optimizer Mode

The mode under which the SQL statement was executed.

Command Type

The Oracle command type (2, for example, represents an INSERT command).


The name used to connect to the Oracle instance.


The name of the module (if any) being executed when the SQL statement was first parsed.

Child Number

The number of the cursor (if any) that is a child of the cursor that contains the SQL statement.

Hash Value

The hash value for the SQL statement in the library cache.

Last Load Time

The last time the SQL statement was loaded.

Parsing Schema Name

The schema name that was used to build the child cursor.

Object Status

The status of the cursor.

Outline Category

The category (if any) of the outline applied during construction of the cursor.


The name of the action being executed when the SQL statement was first parsed.

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