Sessions 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.
Use this page to determine which sessions are benefiting from the use of the In-Memory column store.
To open the Sessions page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click Configuration & Memory | In-Memory Page | Sessions Page.
Top Sessions by IM Scans Grid
Show the top 100 active sessions in descending order of their use of the in-memory column store (MB/GB).
Tip: Double-click on a Session to open that session in the Top Sessions drilldown.
| Column | Description |
|---|---|
| SID | The session identifier. |
| Oracle User | The Oracle user who started the session. |
| OS User | The operating system user for the client. |
| Machine | The name of the computer on which the client is running. |
| Logical Reads (blocks/s) | The rate at which data was read from SGA (not the In-Memory column store) in the preceding sampling interval. |
| IM Scans (blocks/s) | The rate at which data (blocks) was read from the In-Memory column store in the preceding sampling interval. |
| CPU Time (ms/s) |
The rate of CPU time (ms/s) used in the preceding sampling interval. |
| DB Time (ms/s) |
The rate of time spent performing user calls on the session in the preceding sampling interval. |
| IM Scans (Mbytes/s) | The rate at which data (Megabytes) was read from the In-Memory column store in the preceding sampling interval. |
| Disk Reads/s | The number of disk reads per second in the preceding sampling interval. |
| PGA Memory (Mbytes) | The amount of PGA memory used by the session. |
| Total IM Scans (Mbytes) | Total number of megabytes scanned from the In-Memory column store since the session connected. |
| Container Name |
The name of the container for the pluggable database. |
| Serial # | The serial number of the session. |
| SidSerial | The SID and Serial# combined and separated by '_'. This combination is always unique. |
| Total Consistent Gets | Total number of consistent (query) mode reads since the session connected. |
| Total CPU Time (ms) | Total amount of CPU time used since the session connected. |
| Total DB Block Gets | Total number of block gets since the session connected. |
| Total DB Time (ms) | Total amount of DB time (time spent processing user calls) since the session connected. |
| Total IM Scans (blocks) | Total number of blocks scanned from the In-Memory column store since the session connected. |
| Total Physical Reads | Total number of physical reads since the session connected. |