sys_bkgd_migration_retry_num

2025-11-14 07:33:33  Updated

Note

This parameter is available starting with V2.2.50.

Description

sys_bkgd_migration_retry_num specifies the maximum number of retries for a background migration task.

Privilege requirements

  • Query the parameter

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

  • Modify the parameter

    Only the sys tenant can modify the parameter. User tenants cannot modify the parameter.

Attributes

Attribute Description
Type Int
Default value 3
Value range [3, 100]
Modifiable Yes. You can use the ALTER SYSTEM SET statement to modify the parameter.
Effective upon OBServer node restart No. The setting takes effect immediately.

Examples

Set the maximum number of retries for a background migration task to 3.

obclient> ALTER SYSTEM SET sys_bkgd_migration_retry_num = 3;

References

Contact Us