--- title: "查看后台的分区均衡任务 - OceanBase 数据库 V4.5.0 | OceanBase 文档中心" description: "查看后台的分区均衡任务 触发分区均衡任务后，可通过视图查看相关任务的执行情况。 系统租户查看后台的分区均衡任务 使用 root 用户登录集群的 sys 租户。 连接示例如下，连接数据库时请以实际环境为准。 obclient -h10.xx.xx.xx -P2883 -uroot@sys#obdemo -p***** …" --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.5.0 # 查看后台的分区均衡任务 更新时间：2026-04-09 13:57:39 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.5.0/zh-CN/600.manage/350.load-balancing-manage/600.partition-balance-management/500.view-background-partition-balancing-task.md) 触发分区均衡任务后，可通过视图查看相关任务的执行情况。 ## 系统租户查看后台的分区均衡任务 1. 使用 `root` 用户登录集群的 sys 租户。 连接示例如下，连接数据库时请以实际环境为准。 ```shell obclient -h10.xx.xx.xx -P2883 -uroot@sys#obdemo -p***** -A ``` 2. 执行以下语句，查看指定租户后台正在执行的分区均衡任务。 - 查看指定租户正在执行的分区均衡任务。 视图 `CDB_OB_BALANCE_JOBS` 展示了所有租户当前正在执行的宏观层面的均衡任务，包括扩容、缩容、迁移均衡、分区均衡等任务。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BALANCE_JOBS WHERE TENANT_ID = 1002 AND JOB_TYPE = 'PARTITION_BALANCE'; ``` 查询结果如下： ```shell +-----------+--------+----------------------------+----------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ | TENANT_ID | JOB_ID | CREATE_TIME | MODIFY_TIME | BALANCE_STRATEGY | JOB_TYPE | TARGET_UNIT_NUM | TARGET_PRIMARY_ZONE_NUM | STATUS | COMMENT | MAX_END_TIME | ZONE_UNIT_NUM_LIST | PARAMETER_LIST | +-----------+--------+----------------------------+----------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ | 1002 | 374412 | 2024-06-14 14:39:38.710194 | 2024-06-14 14:39:38.710194 | partition attribution alignment | PARTITION_BALANCE | NULL | 1 | DOING | NULL | NULL | zone1:1 | ls_scale_out_factor:1,enable_rebalance:true,enable_transfer:true,enable_gts_standalone:false | +-----------+--------+----------------------------+----------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ 1 row in set ``` 有关视图 `CDB_OB_BALANCE_JOBS` 中各字段的详细说明，参见 [CDB_OB_BALANCE_JOBS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477590)。 - 查看指定租户正在执行的 LS 级别的分区均衡任务。 视图 `CDB_OB_BALANCE_TASKS` 展示了所有租户当前正在执行的日志流级别的任务，包括 LS 分裂（LS_SPLIT）、 LS 合并（LS_MERGE）、LS Transfer（LS_TRANSFER）、修改 LS 属性（LS_ALTER）等任务。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BALANCE_TASKS WHERE TENANT_ID = 1002 AND BALANCE_STRATEGY LIKE '%partition%'; ``` 查询结果如下： ```shell +-----------+---------+----------------------------+----------------------------+-------------+--------+---------+---------------------------------------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ | TENANT_ID | TASK_ID | CREATE_TIME | MODIFY_TIME | TASK_TYPE | SRC_LS | DEST_LS | PART_LIST | FINISHED_PART_LIST | PART_COUNT | FINISHED_PART_COUNT | LS_GROUP_ID | STATUS | PARENT_LIST | CHILD_LIST | CURRENT_TRANSFER_TASK_ID | JOB_ID | COMMENT | BALANCE_STRATEGY | +-----------+---------+----------------------------+----------------------------+-------------+--------+---------+---------------------------------------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ | 1002 | 374414 | 2024-06-14 14:39:38.710194 | 2024-06-14 14:39:42.356430 | LS_TRANSFER | 1002 | 1001 | 500224:500224,500229:500229,500234:500234,500239:500239,500244:500244,500249:500249,500254:500254 | NULL | 7 | 0 | 1001 | TRANSFER | | 374415 | 3 | 374412 | | partition attribution alignment | | 1002 | 374415 | 2024-06-14 14:39:38.710194 | 2024-06-14 14:39:38.710194 | LS_ALTER | 1002 | -1 | NULL | NULL | 0 | 0 | 0 | INIT | 374414 | NULL | -1 | 374412 | NULL | partition attribution alignment | +-----------+---------+----------------------------+----------------------------+-------------+--------+---------+---------------------------------------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ 2 rows in set ``` 有关视图 `CDB_OB_BALANCE_TASKS` 中各字段的详细说明，参见 [CDB_OB_BALANCE_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477539)。 - 查看指定租户正在执行的 Tablet 级别的分区均衡任务。 视图 `CDB_OB_TRANSFER_TASKS` 展示了所有租户当前正在执行的 Tablet 级别的任务，即展示具体对租户的哪些分区和 Tablet 进行 Transfer 操作。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_TRANSFER_TASKS WHERE TENANT_ID = 1002\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TENANT_ID:1002 TASK_ID: 3 CREATE_TIME: 2024-06-14 14:39:42.356430 MODIFY_TIME: 2024-06-14 14:38:44.315350 SRC_LS: 1002 DEST_LS: 1001 PART_LIST: 500224:500224,500229:500229,500234:500234,500239:500239,500244:500244,500249:500249,500254:500254 PART_COUNT: 7 NOT_EXIST_PART_LIST: NULL LOCK_CONFLICT_PART_LIST: NULL TABLE_LOCK_TABLET_LIST: NULL TABLET_LIST: 200089:0,200090:0,200091:0,200092:0,200093:0,200094:0,200095:0,1152921504606847076:0,1152921504606847077:0,1152921504606847078:0,1152921504606847079:0,1152921504606847080:0,1152921504606847081:0,1152921504606847082:0,1152921504606847083:0,1152921504606847084:0,1152921504606847085:0,1152921504606847086:0,1152921504606847087:0,1152921504606847088:0,1152921504606847089:0,1152921504606847090:0,1152921504606847091:0,1152921504606847092:0,1152921504606847093:0,1152921504606847094:0,1152921504606847095:0,1152921504606847096:0,1152921504606847097:0,1152921504606847098:0,1152921504606847099:0,1152921504606847100:0,1152921504606847101:0,1152921504606847102:0,1152921504606847103:0 TABLET_COUNT: 35 START_SCN: 1718347182784953001 FINISH_SCN: 0 STATUS: DOING TRACE_ID: YB42AC1E87DC-00061AC2E77146D7-0-0 RESULT: 0 BALANCE_TASK_ID: 374414 TABLE_LOCK_OWNER_ID: 374434 COMMENT: 1 row in set ``` 有关视图 `CDB_OB_TRANSFER_TASKS` 中各字段的详细说明，参见 [CDB_OB_TRANSFER_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477594)。 ## 用户租户查看后台的分区均衡任务 1. 用户租户的租户管理员登录集群的 MySQL 租户或 Oracle 租户。 ```shell obclient -h10.xx.xx.xx -P2883 -uroot@mysql_tenant#obdemo -p***** -A ``` 2. 执行以下语句，查看本租户后台正在执行的分区均衡任务。 MySQL 模式 Oracle 模式 - 查看指定租户正在执行的分区均衡任务。 视图 `DBA_OB_BALANCE_JOBS` 展示了当前租户正在执行的宏观层面的均衡任务，包括扩容、缩容、迁移均衡、分区均衡等任务。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BALANCE_JOBS WHERE JOB_TYPE = 'PARTITION_BALANCE'; ``` 查询结果如下： ```shell +--------+----------------------------+----------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ | JOB_ID | CREATE_TIME | MODIFY_TIME | BALANCE_STRATEGY | JOB_TYPE | TARGET_UNIT_NUM | TARGET_PRIMARY_ZONE_NUM | STATUS | COMMENT | MAX_END_TIME | ZONE_UNIT_NUM_LIST | PARAMETER_LIST | +--------+----------------------------+----------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ | 374412 | 2024-06-14 14:39:38.710194 | 2024-06-14 14:39:38.710194 | partition attribution alignment | PARTITION_BALANCE | NULL | 1 | DOING | NULL | NULL | zone1:1 | ls_scale_out_factor:1,enable_rebalance:true,enable_transfer:true,enable_gts_standalone:false | +--------+----------------------------+----------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ 1 row in set ``` 有关视图 `DBA_OB_BALANCE_JOBS` 中各字段的详细说明，参见 [DBA_OB_BALANCE_JOBS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004478303)。 - 查看指定租户正在执行的 LS 级别的分区均衡任务。 视图 `DBA_OB_BALANCE_TASKS` 展示了当前租户正在执行的日志流级别的任务，包括 LS 分裂（LS_SPLIT）、 LS 合并（LS_MERGE）、LS Transfer（LS_TRANSFER）、修改 LS 属性（LS_ALTER）等任务。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BALANCE_TASKS WHERE BALANCE_STRATEGY LIKE '%partition%'; ``` 查询结果如下： ```shell +---------+----------------------------+----------------------------+-------------+--------+---------+---------------------------------------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ | TASK_ID | CREATE_TIME | MODIFY_TIME | TASK_TYPE | SRC_LS | DEST_LS | PART_LIST | FINISHED_PART_LIST | PART_COUNT | FINISHED_PART_COUNT | LS_GROUP_ID | STATUS | PARENT_LIST | CHILD_LIST | CURRENT_TRANSFER_TASK_ID | JOB_ID | COMMENT | BALANCE_STRATEGY | +---------+----------------------------+----------------------------+-------------+--------+---------+---------------------------------------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ | 374414 | 2024-06-14 14:39:38.710194 | 2024-06-14 14:39:42.356430 | LS_TRANSFER | 1002 | 1001 | 500224:500224,500229:500229,500234:500234,500239:500239,500244:500244,500249:500249,500254:500254 | NULL | 7 | 0 | 1001 | TRANSFER | | 374415 | 3 | 374412 | | partition attribution alignment | | 374415 | 2024-06-14 14:39:38.710194 | 2024-06-14 14:39:38.710194 | LS_ALTER | 1002 | -1 | NULL | NULL | 0 | 0 | 0 | INIT | 374414 | NULL | -1 | 374412 | NULL | partition attribution alignment | +---------+----------------------------+----------------------------+-------------+--------+---------+---------------------------------------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ 2 rows in set ``` 有关视图 `DBA_OB_BALANCE_TASKS` 中各字段的详细说明，参见 [DBA_OB_BALANCE_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004478257)。 - 查看指定租户正在执行的 Tablet 级别的分区均衡任务。 视图 `DBA_OB_TRANSFER_TASKS` 展示了当前租户正在执行的 Tablet 级别的任务，即展示具体对租户的哪些分区和 Tablet 进行 Transfer 操作。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TRANSFER_TASKS\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TASK_ID: 3 CREATE_TIME: 2024-06-14 14:39:42.356430 MODIFY_TIME: 2024-06-14 14:38:44.315350 SRC_LS: 1002 DEST_LS: 1001 PART_LIST: 500224:500224,500229:500229,500234:500234,500239:500239,500244:500244,500249:500249,500254:500254 PART_COUNT: 7 NOT_EXIST_PART_LIST: NULL LOCK_CONFLICT_PART_LIST: NULL TABLE_LOCK_TABLET_LIST: NULL TABLET_LIST: 200089:0,200090:0,200091:0,200092:0,200093:0,200094:0,200095:0,1152921504606847076:0,1152921504606847077:0,1152921504606847078:0,1152921504606847079:0,1152921504606847080:0,1152921504606847081:0,1152921504606847082:0,1152921504606847083:0,1152921504606847084:0,1152921504606847085:0,1152921504606847086:0,1152921504606847087:0,1152921504606847088:0,1152921504606847089:0,1152921504606847090:0,1152921504606847091:0,1152921504606847092:0,1152921504606847093:0,1152921504606847094:0,1152921504606847095:0,1152921504606847096:0,1152921504606847097:0,1152921504606847098:0,1152921504606847099:0,1152921504606847100:0,1152921504606847101:0,1152921504606847102:0,1152921504606847103:0 TABLET_COUNT: 35 START_SCN: 1718347182784953001 FINISH_SCN: 0 STATUS: DOING TRACE_ID: YB42AC1E87DC-00061AC2E77146D7-0-0 RESULT: 0 BALANCE_TASK_ID: 374414 TABLE_LOCK_OWNER_ID: 374434 COMMENT: 1 row in set ``` 有关视图 `DBA_OB_TRANSFER_TASKS` 中各字段的详细说明，参见 [DBA_OB_TRANSFER_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004478334)。 - 查看指定租户正在执行的分区均衡任务。 ```shell obclient [SYS]> SELECT * FROM SYS.DBA_OB_BALANCE_JOBS WHERE JOB_TYPE = 'PARTITION_BALANCE'; ``` 查询结果如下： ```shell +--------+------------------------------+------------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ | JOB_ID | CREATE_TIME | MODIFY_TIME | BALANCE_STRATEGY | JOB_TYPE | TARGET_UNIT_NUM | TARGET_PRIMARY_ZONE_NUM | STATUS | COMMENT | MAX_END_TIME | ZONE_UNIT_NUM_LIST | PARAMETER_LIST | +--------+------------------------------+------------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ | 370858 | 14-JUN-24 02.22.54.870414 PM | 14-JUN-24 02.22.54.870414 PM | partition attribution alignment | PARTITION_BALANCE | NULL | 1 | DOING | NULL | NULL | zone1:1 | ls_scale_out_factor:1,enable_rebalance:true,enable_transfer:true,enable_gts_standalone:false | +--------+------------------------------+------------------------------+---------------------------------+-------------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+ 1 row in set ``` 有关视图 `DBA_OB_BALANCE_JOBS` 中各字段的详细说明，参见 [DBA_OB_BALANCE_JOBS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477237)。 - 查看指定租户正在执行的 LS 级别的分区均衡任务。 ```shell obclient [SYS]> SELECT * FROM SYS.DBA_OB_BALANCE_TASKS WHERE BALANCE_STRATEGY LIKE '%partition%'; ``` 查询结果如下： ```shell +---------+------------------------------+------------------------------+-------------+--------+---------+-----------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ | TASK_ID | CREATE_TIME | MODIFY_TIME | TASK_TYPE | SRC_LS | DEST_LS | PART_LIST | FINISHED_PART_LIST | PART_COUNT | FINISHED_PART_COUNT | LS_GROUP_ID | STATUS | PARENT_LIST | CHILD_LIST | CURRENT_TRANSFER_TASK_ID | JOB_ID | COMMENT | BALANCE_STRATEGY | +---------+------------------------------+------------------------------+-------------+--------+---------+-----------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ | 370859 | 14-JUN-24 02.22.54.870414 PM | 14-JUN-24 02.22.55.737260 PM | LS_ALTER | 1002 | -1 | NULL | NULL | 0 | 0 | 1001 | ALTER_LS | NULL | 370860 | -1 | 370858 | NULL | partition attribution alignment | | 370860 | 14-JUN-24 02.22.54.870414 PM | 14-JUN-24 02.22.54.870414 PM | LS_TRANSFER | 1002 | 1001 | 500048:500048,500051:500051,500054:500054,500057:500057,500060:500060 | NULL | 5 | 0 | 1001 | INIT | 370859 | 370861 | -1 | 370858 | NULL | partition attribution alignment | | 370861 | 14-JUN-24 02.22.54.870414 PM | 14-JUN-24 02.22.54.870414 PM | LS_ALTER | 1002 | -1 | NULL | NULL | 0 | 0 | 0 | INIT | 370860 | NULL | -1 | 370858 | NULL | partition attribution alignment | +---------+------------------------------+------------------------------+-------------+--------+---------+-----------------------------------------------------------------------+--------------------+------------+---------------------+-------------+----------+-------------+------------+--------------------------+--------+---------+---------------------------------+ 3 rows in set ``` 有关视图 `DBA_OB_BALANCE_TASKS` 中各字段的详细说明，参见 [DBA_OB_BALANCE_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477439)。 - 查看指定租户正在执行的 Tablet 级别的分区均衡任务。 ```shell obclient [SYS]> SELECT * FROM SYS.DBA_OB_TRANSFER_TASKS\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TASK_ID: 2 CREATE_TIME: 14-JUN-24 02.22.58.755501 PM MODIFY_TIME: 14-JUN-24 02.22.59.267311 PM SRC_LS: 1002 DEST_LS: 1001 PART_LIST: 500048:500048,500051:500051,500054:500054,500057:500057,500060:500060 PART_COUNT: 5 NOT_EXIST_PART_LIST: NULL LOCK_CONFLICT_PART_LIST: NULL TABLE_LOCK_TABLET_LIST: NULL TABLET_LIST: 200015:0,200016:0,200017:0,200018:0,200019:0,1152921504606847003:0,1152921504606847004:0,1152921504606847005:0,1152921504606847006:0,1152921504606847007:0,1152921504606847008:0,1152921504606847009:0,1152921504606847010:0,1152921504606847011:0,1152921504606847012:0 TABLET_COUNT: 15 START_SCN: 1718346179101597002 FINISH_SCN: 0 STATUS: DOING TRACE_ID: YB42AC1E87DC-00061AC2EE11426E-0-0 RESULT: 0 BALANCE_TASK_ID: 370860 TABLE_LOCK_OWNER_ID: 370880 COMMENT: NULL 1 row in set ``` 有关视图 `DBA_OB_TRANSFER_TASKS` 中各字段的详细说明，参见 [DBA_OB_TRANSFER_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004477430)。 ## 相关文档 [查看后台的分区均衡任务历史](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004476018) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线