9.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

OWNER

VARCHAR2(128)

User name of the segment owner

SEGMENT_NAME

VARCHAR2(128)

Name of the segment, if any

PARTITION_NAME

VARCHAR2(128)

Object partition name (set to NULL for non-partitioned objects)

SEGMENT_TYPE

VARCHAR2(18)

Type of segment:

  • TABLE

  • TABLE PARTITION

  • TABLE SUBPARTION

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace containing the segment

INMEMORY_SIZE

NUMBER

Size of the in-memory version of the segment, in bytes

BYTES

NUMBER

Number of on-disk data bytes for the segment that could be represented in memory (no space metadata blocks)

BYTES_NOT_POPULATED

NUMBER

Size of the portion of the on-disk segment that is not populated in memory, in bytes.

POPULATE_STATUS

VARCHAR2(13)

Status of segment population:

  • STARTED: A populate task for the segment has started

  • COMPLETED: There are no populate tasks pending for the segment

  • OUT OF MEMORY: A populate task for the segment failed due to lack of space in the IM column store

INMEMORY_PRIORITY

VARCHAR2(8)

Indicates the priority for IM column store population:

  • LOW

  • MEDIUM

  • HIGH

  • CRITICAL

  • NONE

INMEMORY_DISTRIBUTE

VARCHAR2(15)

Indicates how the IM column store is distributed in an Oracle Real Application Clusters (Oracle RAC) environment:

  • AUTO

  • BY ROWID RANGE

  • BY PARTITION

  • BY SUBPARTITION

INMEMORY_DUPLICATE

VARCHAR2(13)

Indicates the duplicate setting for the IM column store in an Oracle RAC environment:

  • NO DUPLICATE

  • DUPLICATE

  • DUPLICATE ALL

INMEMORY_COMPRESSION

VARCHAR2(17)

Compression level for the IM column store:

  • NO MEMCOMPRESS

  • FOR DML

  • FOR QUERY [ LOW | HIGH ]

  • FOR CAPACITY [ LOW | HIGH ]

  • AUTO

INMEMORY_SERVICE

VARCHAR2(12)

Specifies how the IM-enabled table is populated on various instances:

  • DEFAULT: Pre-Oracle Database 12c Release 2 (12.2.0.1) behavior

  • NONE: Do not populate on any instance

  • ALL: Populate on all instances

  • USER_DEFINED: Populate only on the instances on which the user-specified service is active. The service name corresponding to this is stored in the INMEMORY_SERVICE_NAME column.

INMEMORY_SERVICE_NAME

VARCHAR2(129)

Specifies the service name on which the IM-enabled table should be populated. This column has a value only when the corresponding INMEMORY_SERVICE column has a value of USER_DEFINED.

IS_EXTERNAL

VARCHAR2(5)

Indicates whether the IM segment is for an external table. Possible values:

  • TRUE: The IM segment is for an external table.

  • FALSE: The IM segment is not for an external table.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also: