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