Purpose
The DBA_OB_BALANCE_JOB_HISTORY view displays the history of all load balancing jobs executed in the current tenant.
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 end time of the job, which can be the time when the job was executed or canceled. |
| 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 | CLOB | YES | The comments. |
