Note
This view is available starting with V4.2.0.
Purpose
This view displays the load balancing jobs that are being executed for the current tenant. Each tenant can have only one load balancing job running at a time. Each load balancing job generates multiple load balancing tasks, which are used to perform the specific operations of load balancing.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The ID of the load balancing job. |
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the job was created. |
| MODIFY_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the information was last updated. |
| BALANCE_STRATEGY | VARCHAR2(64) | NO | The name of the balancing strategy. Valid values:
|
| JOB_TYPE | VARCHAR2(64) | NO | The type of the task.
|
| TARGET_UNIT_NUM | NUMBER | NO | The number of units in each zone that are changed.
Note
|
| TARGET_PRIMARY_ZONE_NUM | NUMBER(38) | NO | The number of primary zones that are changed. |
| STATUS | VARCHAR2(64) | NO | The status of the task. Valid values:
|
| COMMENT | longtext | YES | The comment. |
| COMMENT | CLOB | YES | The comment. |
| MAX_END_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The maximum end time of the load balancing task.
NoteFor V4.3.x, this view is available starting with V4.3.4. For V4.2.x, this column is available starting with V4.2.4. |
| ZONE_UNIT_NUM_LIST | VARCHAR2(4096) | NO | The number of units in each zone of the tenant.
Note
|
| PARAMETER_LIST | CLOB | NO | The parameters of the balancing-related configurations.
Note
|
Sample query
Query the load balancing jobs that are being executed for the current tenant.
obclient(SYS@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_BALANCE_JOBS;
The query result is as follows:
+--------+----------------------------+----------------------------+-------------------------+------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+
| 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 |
+--------+----------------------------+----------------------------+-------------------------+------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+
| 120112 | 16-JAN-26 17:37:21.308318 | 16-JAN-26 17:37:21.308318 | alter LS group location | LS_BALANCE | NULL | 2 | DOING | NULL | NULL | z1:1,z2:1 | ls_scale_out_factor:1,enable_rebalance:true,enable_transfer:true,enable_gts_standalone:false |
+--------+----------------------------+----------------------------+-------------------------+------------+-----------------+-------------------------+--------+---------+--------------+--------------------+----------------------------------------------------------------------------------------------+
1 row in set
References
Query the history of log stream-level load balancing jobs (Job) for the current tenant: DBA_OB_BALANCE_JOB_HISTORY
Query the log stream-level load balancing tasks (Task) for the current tenant:
Query the tablet-level load balancing tasks (Task) for the current tenant:
Query the Transfer Partition tasks (Task) for the current tenant:
For more information about data load balancing, see Data load balancing.