Note
This view is available starting with V4.0.0.
Overview
Displays the information about the MemTables and SSTables under each partition of the current tenant on the current OBServer node.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | Server IP Address |
| SVR_PORT | NUMBER(38) | NO | Server Port Number |
| TABLE_TYPE | VARCHAR2(20) | NO | Table type |
| LS_ID | NUMBER(38) | NO | Log Stream ID |
| TABLET_ID | NUMBER(38) | NO | Data Shard ID |
| START_LOG_SCN | NUMBER(38) | NO | The left boundary of the log timestamp range for the data in this table. |
| END_LOG_SCN | NUMBER(38) | NO | Right Boundary of Log Timestamp Range for Data in This Table |
| SIZE | NUMBER(38) | NO | Disk usage, in bytes |
| REF | NUMBER(38) | NO | The count of references to this table, in units of number |
| UPPER_TRANS_VERSION | NUMBER(38) | NO | Maximum Transaction Version Number of a Committed Transaction |
| IS_ACTIVE | VARCHAR2(3) | NO | Whether it is an active MemTable |
| CONTAIN_UNCOMMITTED_ROW | VARCHAR2(3) | NO | Whether the table contains uncommitted transaction rows:
|
Sample query
In the user tenant, view the MemTable and SSTable information of each partition for log stream 1001 in the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$OB_SSTABLES WHERE LS_ID=1001;
The query result is as follows:
+----------------+----------+------------------+-------+-----------+---------------------+---------------------+----------+------+---------------------+-----------+-------------------------+
| SVR_IP | SVR_PORT | TABLE_TYPE | LS_ID | TABLET_ID | START_LOG_SCN | END_LOG_SCN | SIZE | REF | UPPER_TRANS_VERSION | IS_ACTIVE | CONTAIN_UNCOMMITTED_ROW |
+----------------+----------+------------------+-------+-----------+---------------------+---------------------+----------+------+---------------------+-----------+-------------------------+
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 49402 | 0 | 1 | 0 | 0 | 1 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MINOR | 1001 | 49402 | 1 | 1743391602135333001 | 4007 | 0 | 4096 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | TX_DATA_MEMTABLE | 1001 | 49402 | 1743391602135333001 | 4611686018427387903 | 1048576 | 3 | 0 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200008 | 0 | 1743357601723336000 | 634 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200017 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200059 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200015 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200007 | 0 | 1743357601723336000 | 710 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200024 | 0 | 1743357601723336000 | 383 | 0 | 1743153227043218000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200016 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200005 | 0 | 1743357601723336000 | 720 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200060 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MEMTABLE | 1001 | 200060 | 1 | 4611686018427387903 | 62914560 | 2 | 9223372036854775807 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200012 | 0 | 1743357601723336000 | 624 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200018 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200013 | 0 | 1743357601723336000 | 623 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 49401 | 0 | 1 | 0 | 0 | 1 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | TX_CTX_MEMTABLE | 1001 | 49401 | 1 | 2 | 0 | 2 | 0 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200004 | 0 | 1743357601723336000 | 720 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 49403 | 0 | 1 | 0 | 0 | 1 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MINI | 1001 | 49403 | 1 | 1743045514426661000 | 0 | 0 | 1743045514426661000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | LOCK_MEMTABLE | 1001 | 49403 | 1 | 1743045514426661000 | 0 | 3 | 0 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200002 | 0 | 1743357601723336000 | 874 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200003 | 0 | 1743357601723336000 | 838 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200006 | 0 | 1743357601723336000 | 725 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200010 | 0 | 1743357601723336000 | 653 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200009 | 0 | 1743357601723336000 | 638 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200011 | 0 | 1743357601723336000 | 633 | 0 | 1742884853812859000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1001 | 200001 | 0 | 1743357601723336000 | 0 | 0 | 1743357601723336000 | NO | NO |
+----------------+----------+------------------+-------+-----------+---------------------+---------------------+----------+------+---------------------+-----------+-------------------------+
29 rows in set