8.3 V$IM_USER_SEGMENTS
V$IM_USER_SEGMENTS
presents information about the in-memory segments for the current user 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 |
---|---|---|
|
|
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 |
|
|
Total size of the on-disk segment, in bytes |
|
|
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 |
|
|
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