8.2 V$IM_SEGMENTS
V$IM_SEGMENTS
presents information about all the in-memory segments in the database.
Only segments that have an in-memory representation are displayed. If a segment is marked for the In-Memory Column Store (IM column store) but is not populated, no corresponding row for that segment is displayed in this view.
Column | Datatype | Description |
---|---|---|
|
|
User name of the segment owner |
|
|
Name of the segment, if any |
|
|
Object partition name (set to NULL for non-partitioned objects) |
|
|
Type of segment:
|
|
|
Name of the tablespace containing the segment |
|
|
Size of the in-memory version of the segment, in bytes |
|
|
Number of on-disk data bytes for the segment that could be represented in memory (no space metadata blocks) |
|
|
Size of the portion of the on-disk segment that is not populated in memory, in bytes. |
|
|
Status of segment population:
|
|
|
Indicates the priority for IM column store population:
|
|
|
Indicates how the IM column store is distributed in an Oracle Real Application Clusters (Oracle RAC) environment:
|
|
|
Indicates the duplicate setting for the IM column store in an Oracle RAC environment:
|
|
|
Compression level for the IM column store:
|
|
|
Specifies how the IM-enabled table is populated on various instances:
|
|
|
Specifies the service name on which the IM-enabled table should be populated. This column has a value only when the corresponding |
|
|
Indicates whether the IM segment is for an external table. Possible values:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
Oracle Database In-Memory Guide for an introduction to the IM column store