Purpose
The V$OB_SSTABLES view displays information about the MemTables and SSTables in each partition on the current OBServer node.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| TABLE_TYPE | varchar(20) | NO | The type of the table. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| TABLET_ID | bigint(20) | NO | The ID of the tablet. |
| START_LOG_SCN | bigint(20) unsigned | NO | The first recorded log timestamp of the data in the table. |
| END_LOG_SCN | bigint(20) unsigned | NO | The last recorded log timestamp of the data in the table. |
| SIZE | bigint(20) | NO | The occupied disk space, in bytes. |
| REF | bigint(20) | NO | The number of references to the table. |
| UPPER_TRANS_VERSION | bigint(20) unsigned | NO | The maximum transaction version of the committed transactions. |
| IS_ACTIVE | varchar(3) | NO | Indicates whether the MemTable is active. |
| CONTAIN_UNCOMMITTED_ROW | varchar(3) | NO | Indicates whether the table contains uncommitted transaction rows. Valid values: NO: The table does not contain any uncommitted transaction rows.YES: The table contains uncommitted transaction rows. |