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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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. |
|
Percentage |
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. |
|
Executions |
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. |
|
SQL ID |
The SQL identifier of the parent SQL cursor in the library cache. |