Note
The view GV$MEMSTORE_INFO was renamed to GV$OB_MEMSTORE_INFO in V4.0.0. In V4.0.0 and later, you must use the new view name GV$OB_MEMSTORE_INFO to query the view. Otherwise, an error will be returned.
Purpose
This view displays the details of MemTables on all partitions of all servers of the current tenant.
Columns
Column |
Type |
Allowable Values |
Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | No | The IP address of the server. |
| SVR_PORT | NUMBER(38) | No | The port of the server. |
| TENANT_ID | NUMBER(38) | No | The ID of the tenant. |
| LS_ID | NUMBER(38) | No | The log stream ID. |
| TABLE_ID | NUMBER(38) | No | The ID of the data shard. |
| IS_ACTIVE | VARCHAR2(3) | No | Whether the MemTable is active. |
| START_SCN | NUMBER(38) | No | The starting SCN of the MemTable. |
| END_SCN | NUMBER(38) | No | The ending SCN of the MemTable. |
| FREEZE_TS | NUMBER(38) | No | The time when the MemTable is frozen. |
Sample query
The following example queries the details of MemTables on all partitions of all servers of the current tenant.
obclient [SYS]> SELECT * FROM SYS.GV$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 | 1004 | 1 | 378 | YES | 1714068002398559906 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 1 | YES | 1714068042428321987 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 377 | YES | 1714068002398559906 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 323 | YES | 1714068002398559906 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 331 | YES | 1714068002398559906 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 121 | YES | 1714068039981365017 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 431 | YES | 1714031571263590534 | 4611686018427387903 | 0 |
| 172.xx.xxx.xxx | 2882 | 1004 | 1 | 373 | YES | 1 | 4611686018427387903 | 0 |
+----------------+----------+-----------+-------+-----------+-----------+---------------------+---------------------+-----------+
8 rows in set