Note: Oracle In-Memory is available for Oracle 12c Release 1 (188.8.131.52) 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
Click Configuration & Memory | In-Memory Page | SQL Page.
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.
|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.|
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.