Note
- This parameter is available starting with V1.4.
- Starting from V4.0.0, the scope of this parameter changes from cluster-level to tenant-level.
Description
major_freeze_duty_time specifies the time when major compactions are triggered.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Moment |
| Default value | 02:00 |
| Value range | [00:00, 23:59] or disable |
| 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. |
Considerations
If the value of major_freeze_duty_time is set to disable, major compactions are disabled.
Examples
Set the time when major compactions are triggered to 02:00.
obclient> ALTER SYSTEM SET major_freeze_duty_time = '02:00';