Spotlight on Oracle 11.0 - Getting Started Guide

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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on Oracle 11.0 - Getting Started Guide

SQL Page