OceanBase Database

SQL - V4.6.0

Download PDF

V$OB_COMPACTION_SUGGESTIONS|V4.6.0|OceanBase Database|docs|OceanBase Documentations

V$OB_COMPACTION_SUGGESTIONS

Last Updated:2026-09-03 07:31:10

This view is available starting with V4.0.0.

Purpose

This view displays the compaction suggestions on the current node.

Column	Type	Nullable	Description
SVR_IP	varchar(46)	NO	The IP address of the server.
SVR_PORT	bigint(20)	NO	The port number of the server.
TENANT_ID	bigint(20)	NO	The tenant ID.
TYPE	varchar(64)	NO	The type of compaction. Valid values: `MDS_TABLE_MERGE`: persists the system's metadata in SSTable format to disk. `MAJOR_MERGE`: major compaction at the tenant level. `MEDIUM_MERGE`: medium compaction at the partition level. `MINI_MERGE`: minor compaction, which converts a MemTable to a Mini SSTable. `MINOR_MERGE`: minor compaction, which merges multiple Mini SSTables into a new Mini SSTable or merges multiple Mini SSTables with one Minor SSTable into a new Minor SSTable. `META_MAJOR_MERGE`: major compaction at the Meta level, which merges data before a specified time into a Meta Major SSTable. This SSTable has the same data format as a Major SSTable and does not contain multi-version data or uncommitted transaction data.
LS_ID	bigint(20)	NO	The ID of the log stream.
TABLET_ID	bigint(20)	NO	The ID of the data tablet.
START_TIME	timestamp(6)	NO	The start time.
FINISH_TIME	timestamp(6)	NO	The end time.
SUGGESTION	varchar(1024)	NO	The suggestion.

Previous topic

Next topic