文档反馈

分布式版-V4.0.0社区版

文档概览
简介
快速上手
应用开发
部署数据库
管理数据库
数据迁移
参考指南
- 系统架构
- SQL 语句
- 系统视图
  - 概述
  - 常见统计事件说明
  - 字典视图
    - 字典视图总览
    - information_schema.CHARACTER_SETS
    - information_schema.CHECK_CONSTRAINTS
    - information_schema.COLLATIONS
    - information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
    - information_schema.COLUMNS
    - information_schema.COLUMN_PRIVILEGES
    - information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
    - information_schema.ENGINES
    - information_schema.GLOBAL_STATUS
    - information_schema.GLOBAL_VARIABLES
    - information_schema.KEY_COLUMN_USAGE
    - information_schema.PARAMETERS
    - information_schema.PARTITIONS
    - information_schema.PROCESSLIST
    - information_schema.REFERENTIAL_CONSTRAINTS
    - information_schema.ROUTINES
    - information_schema.SCHEMA_PRIVILEGES
    - information_schema.SCHEMATA
    - information_schema.SESSION_STATUS
    - information_schema.SESSION_VARIABLES
    - information_schema.STATISTICS
    - information_schema.TABLES
    - information_schema.TABLE_CONSTRAINTS
    - information_schema.TABLE_PRIVILEGES
    - information_schema.USER_PRIVILEGES
    - information_schema.VIEW_TABLE_USAGE
    - information_schema.VIEWS
    - mysql.db
    - mysql.help_category
    - mysql.help_keyword
    - mysql.help_relation
    - mysql.help_topic
    - mysql.proc
    - mysql.time_zone
    - mysql.time_zone_name
    - mysql.time_zone_transition
    - mysql.time_zone_transition_type
    - mysql.user
    - oceanbase.DBA_IND_PARTITIONS
    - oceanbase.DBA_IND_SUBPARTITIONS
    - oceanbase.DBA_OB_DATABASES
    - oceanbase.DBA_OB_LS_LOCATIONS
    - oceanbase.DBA_OB_MAJOR_COMPACTION
    - oceanbase.DBA_OB_RESOURCE_POOLS
    - oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
    - oceanbase.DBA_OB_SERVER_JOBS
    - oceanbase.DBA_OB_SERVERS
    - oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
    - oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
    - oceanbase.DBA_OB_TABLEGROUP_TABLES
    - oceanbase.DBA_OB_TABLEGROUPS
    - oceanbase.DBA_OB_TABLET_REPLICAS
    - oceanbase.DBA_OB_TABLET_TO_LS
    - oceanbase.DBA_OB_TENANT_JOBS
    - oceanbase.DBA_OB_TENANTS
    - oceanbase.DBA_OB_UNIT_JOBS
    - oceanbase.DBA_OB_UNIT_CONFIGS
    - oceanbase.DBA_OB_UNITS
    - oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
    - oceanbase.DBA_OB_ZONES
    - oceanbase.DBA_OBJECTS
    - oceanbase.DBA_PART_INDEXES
    - oceanbase.DBA_PART_KEY_COLUMNS
    - oceanbase.DBA_PART_TABLES
    - oceanbase.DBA_OB_SEQUENCE_OBJECTS
    - oceanbase.DBA_SUBPART_KEY_COLUMNS
    - oceanbase.DBA_SUBPARTITION_TEMPLATES
    - oceanbase.DBA_TAB_PARTITIONS
    - oceanbase.DBA_TAB_SUBPARTITIONS
    - oceanbase.CDB_IND_COLUMNS
    - oceanbase.CDB_IND_PARTITIONS
    - oceanbase.CDB_IND_SUBPARTITIONS
    - oceanbase.CDB_INDEXES
    - oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
    - oceanbase.CDB_OB_DATABASES
    - oceanbase.CDB_OB_LS_LOCATIONS
    - oceanbase.CDB_OB_MAJOR_COMPACTION
    - oceanbase.CDB_OB_RESTORE_HISTORY
    - oceanbase.CDB_OB_RESTORE_PROGRESS
    - oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
    - oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
    - oceanbase.CDB_OB_TABLEGROUP_TABLES
    - oceanbase.CDB_OB_TABLEGROUPS
    - oceanbase.CDB_OB_TABLET_REPLICAS
    - oceanbase.CDB_OB_TABLET_TO_LS
    - oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
    - oceanbase.CDB_OBJECTS
    - oceanbase.CDB_PART_INDEXES
    - oceanbase.CDB_PART_KEY_COLUMNS
    - oceanbase.CDB_PART_TABLES
    - oceanbase.CDB_SUBPART_KEY_COLUMNS
    - oceanbase.CDB_SUBPARTITION_TEMPLATES
    - oceanbase.CDB_TAB_COL_STATISTICS
    - oceanbase.CDB_TAB_COLS
    - oceanbase.CDB_TAB_COLS_V$
    - oceanbase.CDB_TAB_PARTITIONS
    - oceanbase.CDB_TAB_SUBPARTITIONS
    - oceanbase.CDB_TABLES
    - oceanbase.CDB_OB_BACKUP_SET_FILES
    - oceanbase.DBA_OB_BACKUP_SET_FILES
    - oceanbase.CDB_OB_BACKUP_JOBS
    - oceanbase.DBA_OB_BACKUP_JOBS
    - oceanbase.CDB_OB_BACKUP_JOB_HISTORY
    - oceanbase.DBA_OB_BACKUP_JOB_HISTORY
    - oceanbase.CDB_OB_BACKUP_TASKS
    - oceanbase.DBA_OB_BACKUP_TASKS
    - oceanbase.CDB_OB_BACKUP_TASK_HISTORY
    - oceanbase.DBA_OB_BACKUP_TASK_HISTORY
    - oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
    - oceanbase.DBA_OB_RESTORE_PROGRESS
    - oceanbase.DBA_OB_RESTORE_HISTORY
    - oceanbase.CDB_OB_ARCHIVE_DEST
    - oceanbase.DBA_OB_ARCHIVE_DEST
    - oceanbase.CDB_OB_ARCHIVELOG
    - oceanbase.DBA_OB_ARCHIVELOG
    - oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
    - oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
    - oceanbase.CDB_OB_BACKUP_PARAMETER
    - oceanbase.DBA_OB_BACKUP_PARAMETER
    - oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
    - oceanbase.DBA_OB_OUTLINES
    - oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
    - oceanbase.CDB_OB_SYS_VARIABLES
    - oceanbase.CDB_OB_BACKUP_DELETE_JOBS
    - oceanbase.DBA_OB_BACKUP_DELETE_JOBS
    - oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
    - oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
    - oceanbase.CDB_OB_BACKUP_DELETE_TASKS
    - oceanbase.DBA_OB_BACKUP_DELETE_TASKS
    - oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
    - oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
    - oceanbase.CDB_OB_BACKUP_STORAGE_INFO
    - oceanbase.DBA_OB_BACKUP_STORAGE_INFO
    - oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
    - oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
    - oceanbase.CDB_OB_BACKUP_DELETE_POLICY
    - oceanbase.DBA_OB_BACKUP_DELETE_POLICY
    - oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
    - oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
    - oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
    - oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
    - oceanbase.DBA_TAB_STATISTICS
    - oceanbase.DBA_TAB_COL_STATISTICS
    - oceanbase.DBA_PART_COL_STATISTICS
    - oceanbase.DBA_SUBPART_COL_STATISTICS
    - oceanbase.DBA_TAB_HISTOGRAMS
    - oceanbase.DBA_PART_HISTOGRAMS
    - oceanbase.DBA_SUBPART_HISTOGRAMS
    - oceanbase.DBA_TAB_STATS_HISTORY
    - oceanbase.DBA_SCHEDULER_JOBS
    - oceanbase.DBA_IND_STATISTICS
    - oceanbase.DBA_TAB_MODIFICATIONS
    - oceanbase.DBA_SQL_PLAN_BASELINES
    - oceanbase.DBA_SQL_MANAGEMENT_CONFIG
    - information_schema.QUERY_RESPONSE_TIME
    - oceanbase.CDB_OB_LS
    - oceanbase.DBA_OB_LS
    - oceanbase.CDB_OB_TABLE_LOCATIONS
    - oceanbase.DBA_OB_TABLE_LOCATIONS
    - oceanbase.DBA_OB_SERVER_EVENT_HISTORY
    - oceanbase.CDB_OB_FREEZE_INFO
    - oceanbase.DBA_OB_FREEZE_INFO
    - oceanbase.DBA_OB_LS_REPLICA_TASKS
    - oceanbase.CDB_OB_LS_REPLICA_TASKS
    - oceanbase.DBA_OB_AUTO_INCREMENT
    - oceanbase.CDB_OB_AUTO_INCREMENT
    - oceanbase.DBA_SEQUENCES
    - oceanbase.DBA_SCHEDULER_WINDOWS
  - 常见等待事件说明
  - 性能视图
- 系统变量
- 系统配置项
- 错误码
- 预留关键字
- 生态工具
快速入门系列教程
版本发布记录
术语

oceanbase.CDB_OB_MAJOR_COMPACTION

更新时间：2026-06-12 11:11:08

分享

功能

系统租户下展示所有租户的合并全局信息。

字段说明

字段名称	类型	是否可以为 NULL	描述
TENANT_ID	bigint(20)	NO	租户 ID
FROZEN_SCN	bigint(20) unsigned	NO	最近一次合并的版本号
FROZEN_TIME	timestamp(6)	NO	最近一次合并发起的时间（将 FROZEN_SCN 以可读的形式展示）
GLOBAL_BROADCAST_SCN	bigint(20) unsigned	NO	全局广播的合并版本
LAST_SCN	bigint(20) unsigned	NO	上一个已经完成合并的版本
LAST_FINISH_TIME	timestamp(6)	NO	上一次合并结束时间
START_TIME	timestamp(6)	NO	合并开始时间
STATUS	varchar(10)	NO	`IDLE`：没有在合并中 `COMPACTION`：正在合并中 `CHECKSUM`：校验checksum
IS_ERROR	varchar(3)	NO	`YES`：合并过程存在错误 `NO`：合并过程没有报错
IS_SUSPENDED	varchar(3)	NO	`YES`：暂停合并状态 `NO`：没有暂停合并
INFO	varchar(14)	NO	展示合并信息。例如：合并失败原因

有帮助

无帮助

oceanbase.CDB_OB_MAJOR_COMPACTION | OceanBase 文档中心