Welcome to Spotlight
Install Spotlight
Start Spotlight
Spotlight on Oracle
Connect to an Oracle Database
Oracle User Wizard
Spotlight on Oracle Data Guard
DBA Connection Credentials
User Account
New Oracle User
Select Tablespace
Predictive Diagnostics
Ready To Configure Oracle User
End
Configuring Oracle User for Spotlight Dialog
Toad DBA Suite for Oracle
Oracle Architecture Overview
Spotlight on Oracle Home Page
Spotlight on Oracle Alarms
Spotlight on Oracle Drilldowns
Install And Configure DTrace Scripts
Tune Your Oracle Database
Predictive Diagnostics
Spotlight on Oracle Tools: Explain Plan, SQL Optimizer, Space Manager
Standby Connections Dialog
Spotlight on Oracle Data Guard Home Page
Spotlight on Oracle Data Guard Alarms
Spotlight on Oracle RAC
Connect to Spotlight on Oracle RAC
Spotlight on Unix
Oracle RAC Connection Details
Verify Cluster Connection Details Dialog
Connect to an Exadata Storage Server (Cells)
Spotlight on Oracle RAC Home Page
Spotlight on Oracle RAC Alarms
Spotlight on Oracle RAC Drilldowns
Configure the Unix System
Connect to Unix Systems
Spotlight on Unix Home Page
Spotlight on Unix Alarms
Spotlight on Unix Drilldowns
Spotlight on Windows
Connect to Windows Systems
Spotlight on Windows Home Page
Spotlight on Windows Alarms
Spotlight on Windows Drilldowns
Troubleshooting: Connection Problems
SQL Page
Note: Oracle In-Memory is available for Oracle 12c Release 1 (12.1.0.2) and above. Data is displayed for Oracle instances where In-Memory is available and has been enabled. In-Memory is disabled by default.
Investigate the SQL statements making the most use of the In-Memory column store.
To open the SQL page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click Configuration & Memory | In-Memory Page | SQL Page.
SQL Grid
Show the top 200 SQL Statements in descending order of their use of the in-memory column store (in MB).
Note: Only show SQL Statements with In-Memory scan bytes greater than 0.
| Column | Description |
|---|---|
| ID | The SQL identifier of the SQL statement being executed. |
| IM Scans | The number of In-Memory scans on the SQL statement. |
| IM Scan Bytes (Mbytes) | The number of megabytes read from the In-Memory column store. |
| IM Scan Bytes Uncompressed (Mbytes) | The number of megabytes read from the In-Memory column store (uncompressed). The store needs to be uncompressed for the contents to be read. |
| Executions | The number of times the SQL statement has been executed. |
| Avg. Exec. Time (ms) | The average execution time of the SQL statement. |
| SQL Text | The SQL statement executed. |
| Container Name |
The name of the container for the pluggable database. |
| Elapsed Time (ms) | The total elapsed time spent executing the SQL statement. |
| Child_Number | The number of the cursor (if any) that is a child of the cursor that contains the SQL statement. |
| sql_id | The SQL identifier for the SQL statement. |
Tip: Double click on a row (or right click and select SQL Details) to view details of the SQL statement in the Top SQL drilldown.