Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - 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 Page

Note: Available for Oracle 10g and later.

The SQL page displays information on SQL statements associated with specified waiting events.

To open the SQL page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Activity | Waiting Events Page | SQL.

Grid: SQL Statements related to the event

This table contains data only when a wait category (and, optionally, a wait event) is selected in the drop-down list at the top of the page.

Column Description

Plan Hash Value

A numerical value representing the SQL plan for the parent cursor. A comparison of PLAN_HASH_VALUEs can identify whether two SQL plans are the same.

Wait Time

The wait time for the event associated with the SQL statement.


The percentage of total wait time that was consumed by the event associated with the SQL statement.

Buffer Gets

The number of buffer gets performed for all SQL cursors that have this SQL text and plan.

Rows Processed

The total number of rows returned by the parsed SQL statement.


The number of executions that took place on the object referenced by the SQL statement since the object was brought into the library cache.

CPU Time

The CPU time (in microseconds) used by the SQL cursor for parsing, executing, and fetching.

SQL Text

The text of the specified SQL statement.


The SQL identifier of the parent SQL cursor in the library cache.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating