Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The V$OB_COMPACTION_DIAGNOSE_INFO view displays the compaction diagnostic information.
Columns
| Column |
Type |
Nullable? |
Description |
| SVR_IP |
VARCHAR2(46) |
NO |
The IP address of the OBServer node. |
| SVR_PORT |
NUMBER(38) |
NO |
The port number of the OBServer node. |
| TENANT_ID |
NUMBER(38) |
NO |
The ID of the tenant. |
| TYPE |
VARCHAR2(64) |
NO |
The compaction type. Valid values:
MDS_TABLE_MERGE: indicates to persist system metadata to the disk in the SSTable format.MAJOR_MERGE: indicates a tenant-level major compaction.MEDIUM_MERGE: indicates a partition-level major compaction.MINI_MERGE: indicates a mini compaction that converts a MemTable to a mini SSTable.MINOR_MERGE: indicates a minor compaction that combines multiple mini SSTables or multiple mini SSTables and minor SSTables into one minor SSTable.META_MAJOR_MERGE: indicates a special compaction type that compacts the data generated before a specified point in time into a meta major SSTable, which has the same data format as a major SSTable but does not contain multi-version data or data of uncommitted transactions. |
| LS_ID |
NUMBER(38) |
NO |
The ID of the log stream. |
| TABLET_ID |
NUMBER(38) |
NO |
The ID of the tablet. |
| STATUS |
VARCHAR2(15) |
NO |
The status of the task. |
| DIAGNOSE_INFO |
VARCHAR2(1024) |
NO |
The diagnostic information. |
