Note
This view was introduced in OceanBase Database V4.2.0.
Purpose
The DBA_OB_BALANCE_TASKS view displays the ongoing load balancing tasks in the current tenant. Each tenant can have multiple ongoing load balancing tasks, which belong to the same load balancing job.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TASK_ID | NUMBER(38) | NO | The ID of the load balancing task. |
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the task was created. |
| MODIFY_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the task was last modified. |
| TASK_TYPE | VARCHAR2(64) | NO | The type of the task. Valid values:
|
| SRC_LS | NUMBER(38) | NO | The source log stream, which is generated at the data source. |
| DEST_LS | NUMBER(38) | NO | The destination log stream. |
| PART_LIST | CLOB | YES | The list of partitions, including user table partitions and global index partitions. |
| FINISHED_PART_LIST | CLOB | YES | The list of partitions for which load balancing has been completed. |
| PART_COUNT | NUMBER(38) | YES | The number of partitions in the partition list. |
| FINISHED_PART_COUNT | NUMBER(38) | YES | The number of partitions for which load balancing has been completed. |
| LS_GROUP_ID | NUMBER(38) | NO | The ID of the log stream group. |
| STATUS | VARCHAR2(64) | NO | The status of the task. Valid values:
|
| PARENT_LIST | VARCHAR2(1024) | YES | The list of parent tasks. |
| CHILD_LIST | VARCHAR2(1024) | YES | The list of subtasks. |
| CURRENT_TRANSFER_TASK_ID | NUMBER(38) | NO | The ID of the transfer task triggered by the current load balancing task. |
| JOB_ID | NUMBER(38) | NO | The ID of the job to which the current task belongs. |
| COMMENT | CLOB | YES | The comments. |
| BALANCE_STRATEGY | VARCHAR2(64) | YES | The load balancing strategy for the load balancing task.
NoteThis column was introduced in OceanBase Database V4.2.4. |
Sample query
Query the ongoing load balancing tasks in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BALANCE_TASKS\G
Query result:
*************************** 1. row ***************************
TASK_ID: 321373
CREATE_TIME: 2025-05-09 14:45:15.602100
MODIFY_TIME: 2025-05-09 14:45:15.616452
TASK_TYPE: LS_SPLIT
SRC_LS: 1001
DEST_LS: 1002
PART_LIST: 500002:500016,500002:500015,500002:500014,500002:500013,500002:500012,500002:500011
FINISHED_PART_LIST: NULL
PART_COUNT: 6
FINISHED_PART_COUNT: 0
LS_GROUP_ID: 1001
STATUS: CREATE_LS
PARENT_LIST: NULL
CHILD_LIST: NULL
CURRENT_TRANSFER_TASK_ID: -1
JOB_ID: 321371
COMMENT:
BALANCE_STRATEGY: LS balance by expand
1 row in set
References
Query the load balancing tasks at the log stream level in the current tenant: DBA_OB_BALANCE_TASK_HISTORY.
Query the load balancing jobs at the log stream level in the current tenant:
Query the load balancing tasks at the tablet level in the current tenant:
Query the transfer partition tasks in the current tenant:
For more information about data load balancing, see Data load balancing.