Note
The view V$MEMSTORE_INFO was renamed to V$OB_MEMSTORE_INFO in V4.0.0. In V4.0.0 and later, you must use the new view name V$OB_MEMSTORE_INFO to query the view. Otherwise, an error will be returned.
Purpose
This view displays the details of MemTables in all partitions of the current tenant on the current server.
Columns
| Column | Type | Allowable Values | 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 start SCN of the MemTable. |
| END_SCN | bigint(20) unsigned | No | The end SCN of the MemTable. |
| FREEZE_TS | bigint(20) | No | The timestamp when the MemTable is frozen. |
Sample query
The following example shows how to query the details of MemTables in all partitions of the current tenant on the current server.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_MEMSTORE_INFO;
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