Note
The view V$MEMSTORE_INFO was renamed to V$OB_MEMSTORE_INFO in V4.0.0. You must use the new view name V$OB_MEMSTORE_INFO to query data from V4.0.0 and later. Otherwise, an error will be returned.
Purpose
This view displays the details of MemTables in all partitions of all tenants on the server.
Columns
| Column | Type | Required | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | No | The IP address of the server. |
| SVR_PORT | bigint(20) | No | The port of the server. |
| TENANT_ID | bigint(20) | No | The ID of the tenant. |
| LS_ID | bigint(20) | No | The ID of the log stream. |
| TABLE_ID | bigint(20) | No | The ID of the data shard. |
| IS_ACTIVE | varchar(3) | No | Whether the MemTable is active. |
| START_SCN | bigint(20) unsigned | No | The starting SCN of the MemTable. |
| END_SCN | bigint(20) unsigned | No | The ending SCN of the MemTable. |
| FREEZE_TS | bigint(20) | No | The time when the MemTable is frozen. |
Sample query
The following example queries the details of MemTables in all partitions of the tenant with ID 1002 on the server.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_MEMSTORE_INFO WHERE TENANT_ID=1002;
The query result is as follows:
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
| SVR_IP | SVR_PORT | TENANT_ID | LS_ID | TABLET_ID | IS_ACTIVE | START_SCN | END_SCN | FREEZE_TS |
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 378 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 1 | YES | 1714068112628329951 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 377 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 323 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 331 | YES | 1714068002572249530 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 121 | YES | 1714068114066199993 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 431 | YES | 1714031525703603309 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1002 | 1 | 373 | YES | 1 | 4611686018427387903 | 0 |
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
8 rows in set