文档反馈

分布式版-V4.0.0社区版

文档概览
简介
快速上手
应用开发
部署数据库
管理数据库
数据迁移
参考指南
- 系统架构
- SQL 语句
- 系统视图
  - 概述
  - 常见统计事件说明
  - 字典视图
  - 常见等待事件说明
  - 性能视图
    - 性能视图总览
    - GV$OB_COMPACTION_DIAGNOSE_INFO
    - GV$OB_COMPACTION_PROGRESS
    - GV$OB_COMPACTION_SUGGESTIONS
    - GV$OB_KVCACHE
    - GV$OB_PARAMETERS
    - GV$OB_PROCESSLIST
    - GV$OB_PX_TARGET_MONITOR
    - GV$OB_SERVERS
    - GV$OB_TABLET_COMPACTION_HISTORY
    - GV$OB_TABLET_COMPACTION_PROGRESS
    - GV$OB_TRANSACTION_PARTICIPANTS
    - GV$OB_UNITS
    - GV$OB_PLAN_CACHE_STAT
    - GV$OB_PLAN_CACHE_PLAN_STAT
    - GV$SESSION_EVENT
    - GV$SESSION_WAIT
    - GV$SESSION_WAIT_HISTORY
    - GV$SYSTEM_EVENT
    - GV$SESSTAT
    - GV$OB_SQL_AUDIT
    - GV$LATCH
    - GV$OB_MEMORY
    - GV$OB_MEMSTORE
    - GV$OB_PLAN_CACHE_PLAN_EXPLAIN
    - GV$OB_RPC_OUTGOING
    - GV$OB_RPC_INCOMING
    - GV$SQL_PLAN_MONITOR
    - GV$SESSION_LONGOPS
    - GV$OB_PX_WORKER_STAT
    - GV$OB_PS_STAT
    - GV$OB_PS_ITEM_INFO
    - GV$SQL_WORKAREA
    - GV$SQL_WORKAREA_HISTOGRAM
    - GV$OB_SQL_WORKAREA_MEMORY_INFO
    - GV$OB_SERVER_SCHEMA_INFO
    - GV$OB_MERGE_INFO
    - GV$OB_SSTABLES
    - GV$OB_TENANT_MEMORY
    - GV$OB_COMPACTION_DIAGNOSE_INFO
    - V$OB_COMPACTION_PROGRESS
    - V$OB_COMPACTION_SUGGESTIONS
    - V$OB_KVCACHE
    - V$OB_PARAMETERS
    - V$OB_PROCESSLIST
    - V$OB_PX_TARGET_MONITOR
    - V$OB_SERVERS
    - V$OB_TABLET_COMPACTION_HISTORY
    - V$OB_TABLET_COMPACTION_PROGRESS
    - V$OB_TRANSACTION_PARTICIPANTS
    - V$OB_UNITS
    - V$STATNAME
    - V$EVENT_NAME
    - V$SESSION_EVENT
    - V$SESSION_WAIT
    - V$SESSION_WAIT_HISTORY
    - V$SESSTAT
    - V$SYSTEM_EVENT
    - V$OB_MEMORY
    - V$OB_MEMSTORE
    - V$OB_PLAN_CACHE_STAT
    - V$OB_PLAN_CACHE_PLAN_STAT
    - V$OB_PLAN_CACHE_PLAN_EXPLAIN
    - V$OB_SQL_AUDIT
    - V$OB_RPC_OUTGOING
    - V$OB_RPC_INCOMING
    - V$SQL_PLAN_MONITOR
    - V$SESSION_LONGOPS
    - V$LATCH
    - V$OB_PX_WORKER_STAT
    - V$OB_PS_STAT
    - V$OB_PS_ITEM_INFO
    - V$SQL_WORKAREA
    - V$SQL_WORKAREA_ACTIVE
    - V$SQL_WORKAREA_HISTOGRAM
    - V$OB_SQL_WORKAREA_MEMORY_INFO
    - V$OB_SERVER_SCHEMA_INFO
    - V$OB_MERGE_INFO
    - V$SQL_MONITOR_STATNAME
    - V$OB_ENCRYPTED_TABLES
    - V$ENCRYPTED_TABLESPACES
    - V$OB_SSTABLES
    - V$OB_TENANT_MEMORY
    - GV$SQL_WORKAREA_ACTIVE
    - GV$OB_MEMSTORE_INFO
    - V$OB_MEMSTORE_INFO
    - GV$OB_IO_CALIBRATION_STATUS
    - V$OB_IO_CALIBRATION_STATUS
    - GV$OB_IO_BENCHMARK
    - V$OB_IO_BENCHMARK
    - GV$SYSSTAT
    - V$SYSSTAT
    - V$SESSION_EVENT
    - GV$ACTIVE_SESSION_HISTORY
    - V$ACTIVE_SESSION_HISTORY
    - GV$DML_STATS
    - V$DML_STATS
    - GV$OB_LOG_STAT
    - V$OB_LOG_STAT
    - GV$OB_DTL_INTERM_RESULT_MONITOR
    - V$OB_DTL_INTERM_RESULT_MONITOR
    - V$OB_LS_REPLICA_TASK_PLAN
- 系统变量
- 系统配置项
- 错误码
- 预留关键字
- 生态工具
快速入门系列教程
版本发布记录
术语

GV$OB_COMPACTION_DIAGNOSE_INFO

更新时间：2026-07-03 11:43:18

分享

功能

展示 COMPACTION 的诊断信息。

字段说明

字段名称	类型	是否可以为 NULL	描述
SVR_IP	varchar(46)	NO	服务器 IP 地址
SVR_PORT	bigint(20)	NO	服务器端口号
TENANT_ID	bigint(20)	NO	租户 ID
TYPE	varchar(64)	NO	compaction 的类型 `MINI` ：转储/L0 compaction，MemTable 通过转储变成 SSTable `MAJOR` ：合并 `MINI MINOR` ：L1 compaction，多个 Mini sstable 合成一个 `BUF MINOR` ：生成特殊的 buf minor sstable 的 compaction
LS_ID	bigint(20)	NO	日志流 ID
TABLET_ID	bigint(20)	NO	数据分片 ID
STATUS	varchar(15)	NO	任务状态
DIAGNOSE_INFO	varchar(1024)	NO	诊断信息

有帮助

无帮助

GV$OB_COMPACTION_DIAGNOSE_INFO | OceanBase 文档中心