The DBMS_BALANCE system package provides methods for partition balancing.
Privilege requirements
Users and tenants with the privilege to execute PL/SQL statements can use this feature. If the sys tenant calls this feature, an error OB_OP_NOT_ALLOW is returned.
Subprograms of DBMS_BALANCE
The following table lists the DBMS_BALANCE subprograms supported by OceanBase Database and their descriptions.
| Subprogram | Description |
|---|---|
| SET_BALANCE_WEIGHT | Used to manually set the partition weight. |
| CLEAR_BALANCE_WEIGHT | Used to manually clear the partition weight. |
| TRIGGER_PARTITION_BALANCE | Used to manually trigger partition balancing. |