SET_TABLEGROUP_BALANCE_WEIGHT

The SET_TABLEGROUP_BALANCE_WEIGHT procedure is used to set the weight of a table group of the SHARDING NONE type.

Syntax

DBMS_BALANCE.SET_TABLEGROUP_BALANCE_WEIGHT(
    weight                INT,
    tablegroup_name       VARCHAR(65535)
    ); 

Parameters

Considerations

• DBMS_BALANCE.SET_TABLEGROUP_BALANCE_WEIGHT is used to set the weight of a SHARDING NONE table group.

• When enable_database_sharding_none = true, the default weight of the table group bound to the new database is 1. Other SHARDING NONE table groups without specified weights have a default weight of 0 and do not participate in weight balancing.

• Table-level and partition-level weights in weighted table groups are invalid.

• We recommend that you divide the table group weights into three levels:

  • The weight of the first level = 100% * the number of SHARDING NONE table groups.
  • The weight of the second level = 50% * the number of SHARDING NONE table groups.
  • The weight of the third level = 1.

Examples

• Call the procedure in the sys tenant to set the weight of the TG_TD_test table group to 10 in the mysql tenant.

  obclient> CALL DBMS_BALANCE.SET_TABLEGROUP_BALANCE_WEIGHT(10, 'TG_TD_test') TENANT = 'mysql';
  

• Call the procedure in the user tenant to set the weight of the TG_TD_test table group to 10 in the user tenant.

  obclient> CALL DBMS_BALANCE.SET_TABLEGROUP_BALANCE_WEIGHT(10, 'TG_TD_test');
  

References

• For more information about how to remove the weight of a SHARDING NONE table group, see CLEAR_TABLEGROUP_BALANCE_WEIGHT.
• For more information about how to query the weight of a table group, see oceanbase.CDB_OB_DATABASES or oceanbase.DBA_OB_DATABASES.
• For more information about how to control whether automatic aggregation is enabled for user tables when a database is created, see enable_database_sharding_none.