The DBMS_BALANCE package provides methods for partition balancing.
Privilege requirements
Only users with the execute privilege on PL/SQL can use this feature. The sys tenant will receive an error message OB_OP_NOT_ALLOW when it calls 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 |
|---|---|
| TRIGGER_PARTITION_BALANCE | Triggers manual partition balancing. |
| SET_BALANCE_WEIGHT | Sets partition weights manually. |
| CLEAR_BALANCE_WEIGHT | Clears partition weights manually. |