Purpose
v$merge_info displays the statistics related to compactions that have been completed in the OceanBase cluster.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(32) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| 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. |
| TYPE | varchar(5) | NO | The type of the compaction. Valid values: |
| ACTION | varchar(64) | NO | The specific compaction action. Valid values: |
| VERSION | varchar(64) | NO | The version of the compaction. |
| START_TIME | timestamp(6) | NO | The time when the compaction started. |
| END_TIME | timestamp(6) | NO | The time when the compaction ended. |
| MACRO_BLOCK_COUNT | bigint(20) | NO | The total number of macro blocks in the compaction. |
| REUSE_PCT | DECIMAL(26,2) | NO | The reuse rate of macro blocks in the compaction. |
| PARALLEL_DEGREE | bigint(20) | NO | The degree of parallelism of the compaction. |