Note: Oracle In-Memory is available for Oracle 12c Release 1 (126.96.36.199) and above. Data is displayed for Oracle instances where In-Memory is available and has been enabled. In-Memory is disabled by default.
Drilldown on the In-Memory segments consuming the most I/O and disk resources. Assess the time saved by having the segment In-Memory and use this information to determine whether it is worth having the segment in memory.
To open the Segments page
Click Configuration & Memory | In-Memory Page | Segments Page.
Top Segments by In-Memory Scans
Show the memory segments of in-memory tables. Show the segments with the most In-Memory scans (Top 100) in descending order of magnitude.
|Name||The name of the segment. Invariably this segment will be of type table.|
|Owner||The owner of the segment.|
|Populate Status||The status of populating the segment. The status is started, completed or failed.|
Applicable in the case of an Oracle RAC. The DISTRIBUTE clause controls how table data in the In-Memory column store is distributed across Oracle RAC instances.
Applicable in the case of an Oracle RAC. The DUPLICATE clause controls how table data in the In-Memory column store is duplicated across Oracle RAC instances.
The priority determines the order in which segments are populated in the In-Memory column store.
|Size on Disk (Mbytes)||The size of the segment on disk.|
|IM Size (Mbytes)||The size of the segment in the In-Memory column store.|
|Bytes not Populated (Mbytes)||The size of the portion of the on-disk segment that is not populated in memory.|
|Logical Reads||The number of logical reads on the segment.|
|DB Block Changes||The number of DB block changes on the segment.|
|Number of Indexes||The number of indexes in the segment (table).|
|IM Scans||The number of In-Memory scans on the segment.|
|Physical Reads||The number of physical reads on the segment. Physical reads are read from disk.|
The name of the container for the pluggable database.