The DBMS_BALANCE package provides methods for partition balancing.
Privilege requirements
The user tenant that has the privilege to execute PL/SQL statements can use this feature. The sys tenant will return an error OB_OP_NOT_ALLOW when calling this feature.
Subprograms of DBMS_BALANCE
The following table lists the DBMS_BALANCE subprograms supported in the current OceanBase Database version and their descriptions.
| Subprogram | Description |
|---|---|
| SET_BALANCE_WEIGHT | Manually sets the partition weight. |
| CLEAR_BALANCE_WEIGHT | Manually clears the partition weight. |
| TRIGGER_PARTITION_BALANCE | Manually triggers partition balancing. |