Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

SQL Page

Note: Oracle In-Memory is available for Oracle 12c Release 1 ( 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

  1. Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
  2. 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.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating