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
-
Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Top SQL Page.
- Select a SQL Statement in the Top SQL grid.
- Click SQL Details.
Note: Click Full screen for an expanded view of SQL Details. SQL Details (Full Screen) Page
SQL Details
| Data | Description |
|---|---|
|
SQL ID |
The SQL identifier for the specified SQL statement in the library cache. |
|
Address |
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). |
|
Service |
The name used to connect to the Oracle instance. |
|
Module |
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. |
|
Action |
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.
|
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.