Purpose
The oceanbase.DBA_OB_BALANCE_JOBS view displays the ongoing load balancing job of a tenant. Each tenant can have only one running load balancing job at a time. A load balancing job generates multiple load balancing tasks for specific load balancing operations.
Note
This view is introduced since OceanBase Database V4.2.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the load balancing job. |
| CREATE_TIME | timestamp(6) | YES | The time when the job was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the job was last modified. |
| BALANCE_STRATEGY | varchar(64) | NO | The name of the load balancing strategy. Valid values:
|
| JOB_TYPE | varchar(64) | NO | The type of the job. Valid values:
|
| TARGET_UNIT_NUM | bigint(20) | NO | The target number of resource units for each zone. |
| TARGET_PRIMARY_ZONE_NUM | bigint(20) | NO | The target number of primary zones. |
| STATUS | varchar(64) | NO | The status of the job. Valid values:
|
| COMMENT | longtext | YES | The comments. |