V$MEMSTORE_INFO

2023-08-18 09:26:34  Updated

Overview

V$MEMSTORE_INFO displays details about memtables of all partitions of all tenants on the current OBServer.

Field description

Field name Type Nullable Description
CON_ID NUMBER(38) NO The ID of the tenant.
PARTITION_ID NUMBER(38) NO The ID of the partition.
VERSION VARCHAR2(128) NO The freeze version.
BASE_VERSION NUMBER(38) NO The left boundary of the data snapshot version number.
MULTI_VERSION_START NUMBER(38) NO The starting snapshot version of multiversion data.
SNAPSHOT_VERSION NUMBER(38) NO The right boundary of the data snapshot version number.
IS_ACTIVE NUMBER(38) NO Indicates whether the current memtable is active.
USED NUMBER(38) NO The size in bytes of the memory used by the current memtable.
HASH_ITEMS NUMBER(38) NO The number of rows recorded in the Hash index.
BTREE_ITEMS NUMBER(38) NO The number of rows recorded in the Btree index.

Contact Us