Purpose
The oceanbase.CDB_OB_BALANCE_JOBS view displays the ongoing load balancing jobs of all tenants. Each tenant can have only one running load balancing job at a time. A load balancing job will generate 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 |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant.
|
| JOB_ID | bigint(20) | NO | The ID of the load balancing job. |
| CREATE_TIME | timestamp(6) | NO | The time when the job was created. |
| MODIFY_TIME | timestamp(6) | NO | The time when the job was 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 comment on the job. |