partition_balance_schedule_interval

Description

partition_balance_schedule_interval specifies the partition balance schedule interval.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can query this parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify the parameter

  The sys tenant and user tenants can modify this parameter.

Attributes

Considerations

• You can enable partition balance only when the value of the partition_balance_schedule_interval parameter is greater than that of the balancer_idle_time parameter.

• In V4.4.x, the behavior of partition balance is different:

  • V4.4.1 and earlier versions

    The automatic partition balance interval is controlled by this parameter.

  • V4.4.1 and later versions

    Starting from V4.4.1, scheduled partition balance tasks are supported. We recommend that you do not use the partition_balance_schedule_interval parameter to control partition balance.

    • For user tenants created in V4.4.1, the value of the partition_balance_schedule_interval parameter is 0 by default. Scheduled partition balance tasks are enabled by default. Partition balance is triggered by scheduled tasks or manual triggers.

    • For user tenants upgraded to V4.4.1, the value of the partition_balance_schedule_interval parameter remains unchanged from before the upgrade. Scheduled partition balance tasks are disabled by default.

Examples

• Change the partition balance schedule interval of any tenant in the sys tenant to 1 hour.

  obclient(root@sys)[oceanbase]> ALTER SYSTEM SET partition_balance_schedule_interval = '1h' tenant = all;
  obclient(root@sys)[oceanbase]> ALTER SYSTEM SET partition_balance_schedule_interval = '1h' tenant = 'tenant_name';
  

• Change the partition balance schedule interval of the current user tenant to 1 hour.

  obclient [test]> ALTER SYSTEM SET partition_balance_schedule_interval = '1h';