The DBMS_BALANCE system package provides methods for manually triggering partition balancing.
DBMS_BALANCE Privilege Description
Users with the privilege to execute PL/SQL can use this feature. Calling it from the sys tenant will result in an error OB_OP_NOT_ALLOW.
Overview of the DBMS_BALANCE Subprogram
The following table lists the DBMS_BALANCE subprograms supported by the current version of OceanBase Database and their corresponding descriptions.
subprogram |
Description |
|---|---|
| TRIGGER_PARTITION_BALANCE | Manually trigger partition balancing. |