V$OB_TABLET_COMPACTION_PROGRESS

2025-12-02 08:08:09  Updated

Note

Introduced in V4.0.0.

Description

Displays the progress of a tablet-level major compaction.

Field descriptions

Field name Type Nullable Description
SVR_IP VARCHAR2(46) NO The IP address of the server.
SVR_PORT NUMBER(38) NO The port number of the server.
TENANT_ID NUMBER(38) NO The ID of the tenant.
TYPE VARCHAR2(64) NO The type of compaction.
  • MDS_TABLE_MERGE: The system metadata is persisted to the disk in the SSTable format.
  • MAJOR_MERGE: A major compaction at the tenant level.
  • MEDIUM_MERGE: A major compaction at the partition level.
  • MINI_MERGE: A minor compaction that converts MemTables into a Mini SSTable.
  • MINOR_MERGE: A minor compaction that merges multiple Mini SSTables into a new one or merges a Minor SSTable and multiple Mini SSTables into a new one.
  • META_MAJOR_MERGE: A special type of compaction that synthesizes data from the start time to a specified point in time into a Meta Major SSTable. The data in the Meta Major SSTable is in the same format as that in a Major SSTable but does not contain multi-version data or uncommitted transactions.
LS_ID NUMBER(38) NO The ID of the log stream.
TABLET_ID NUMBER(38) NO The ID of the data shard.
COMPACTION_SCN NUMBER(38) NO The version information of the compaction.
TASK_ID VARCHAR2(64) NO The execution trace.
STATUS VARCHAR2(15) NO The status of the task.
DATA_SIZE NUMBER(38) NO The total amount of data to be scanned.
UNFINISHED_DATA_SIZE NUMBER(38) NO The amount of data not scanned yet.
PROGRESSIVE_COMPACTION_ROUND NUMBER(38) NO The progressive compaction round.
CREATE_TIME TIMESTAMP(6) WITH LOCAL TIME ZONE NO The creation time of the task.
START_TIME TIMESTAMP(6) WITH LOCAL TIME ZONE NO The start time.
ESTIMATED_FINISH_TIME TIMESTAMP(6) WITH LOCAL TIME ZONE NO The estimated finish time.
START_CG_ID NUMBER(38) NO The start ID of the column group.

Note

This field is introduced in V4.3.0.

END_CG_ID NUMBER(38) NO The end ID of the column group.

Note

This field is introduced in V4.3.0.

Contact Us