Purpose
Since OceanBase Database V3.0.0, minor compactions for uncommitted transactions are supported. Data involved in the uncommitted transactions is stored in the SSTable. The uncommitted transactions are called dirty transactions. Generally, large transactions are prone to becoming dirty transactions.
v$ob_trans_table_status displays the details of dirty transactions generated for the current tenant after each minor freeze.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_ID | bigint(20) | NO | The ID of the table. |
| PARTITION_ID | bigint(20) | NO | The ID of the partition. |
| END_LOG_ID | bigint(20) | NO | The ID of the persistent transaction log. |
| TRANS_CNT | bigint(20) | NO | The quantity of dirty transactions. |