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.
gv$ob_trans_table_status displays the details of dirty transactions generated after each minor freeze.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the relevant server. |
| SVR_PORT | bigint(20) | NO | The port number of the relevant OBServer node. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| 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. |