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 RAC 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.