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
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center