Purpose
The 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 | 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 job was last modified. |
| BALANCE_STRATEGY | VARCHAR2(64) | NO | The name of the load balancing strategy. Valid values:
|
| JOB_TYPE | VARCHAR2(64) | NO | The type of the job. Valid values:
|
| TARGET_UNIT_NUM | NUMBER(38) | NO | The target number of resource units for each zone. |
| TARGET_PRIMARY_ZONE_NUM | NUMBER(38) | NO | The target number of primary zones. |
| STATUS | VARCHAR2(64) | NO | The status of the job. Valid values:
|
| COMMENT | longtext | YES | The comments. |
| COMMENT | CLOB | YES | The comments. |