Purpose
v$sstable displays the SSTable information of a tenant.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_TYPE | bigint(20) | NO | The type of the table. |
| TABLE_ID | bigint(20) | NO | The ID of the table. |
| TABLE_NAME | varchar(256) | NO | The name of the table. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| PARTITION_ID | bigint(20) | NO | The ID of the partition. |
| INDEX_ID | bigint(20) | NO | The ID of the primary table or index table. |
| BASE_VERSION | bigint(20) | NO | The minimum trans_version that stores data in the table. |
| MULTI_VERSION_START | bigint(20) | NO | The initial trans_version that stores data of multiple versions in the table. |
| SNAPSHOT_VERSION | bigint(20) | NO | The maximum trans_version that stores data in the table. |
| START_LOG_TS | bigint(20) unsigned | NO | The first recorded log timestamp of the data in the table. |
| END_LOG_TS | bigint(20) unsigned | NO | The last recorded log timestamp of the data in the table. |
| MAX_LOG_TS | bigint(20) unsigned | NO | The maximum value of the recorded log timestamp of the data in the table. |
| VERSION | bigint(20) | NO | The version of the table. |
| LOGICAL_DATA_VERSION | bigint(20) | NO | The version of the logical data in the table. |
| SIZE | bigint(20) | NO | The size of the table. |
| IS_ACTIVE | bigint(20) | NO | Indicates whether the table is active. |
| REF | bigint(20) | NO | The counted number of references to the table. |
| WRITE_REF | bigint(20) | NO | The counted number of references to the table for write operations. |
| TRX_COUNT | bigint(20) | NO | The number of active transactions in the table. |
| PENDING_LOG_PERSISTING_ROW_CNT | bigint(20) | NO | The number of persistent redo logs that are recycled. |
| UPPER_TRANS_VERSION | bigint(20) | NO | The upper limit of trans_version that stores data in the table. |
| CONTAIN_UNCOMMITTED_ROW | tinyint(4) | NO | Indicates whether the table contains uncommitted transaction rows. Valid values: |