The DBMS_BALANCE package provides methods for partition balancing.
Privilege requirements
Only users with the privilege to execute PL/SQL can use this feature. If the sys tenant calls this feature, an error OB_OP_NOT_ALLOW is returned.
Subprograms
The following table describes the DBMS_BALANCE subprograms supported in the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| TRIGGER_PARTITION_BALANCE | Triggers manual partition balancing. |
| SET_BALANCE_WEIGHT | Manually sets the partition weight. |
| CLEAR_BALANCE_WEIGHT | Manually clears the partition weight. |