Note
- This parameter is available starting with V1.4.
- Starting from V4.0.0, the scope of this parameter is changed from cluster-level to tenant-level.
Description
major_freeze_duty_time specifies the time at which major compactions and major freezes are triggered.
Privilege requirements
Query the parameter
The sys tenant and all user tenants can query this parameter by using the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The sys tenant 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, the daily major compaction feature is disabled.
Examples
Set the trigger time for daily major compactions to 02:00.
obclient> ALTER SYSTEM SET major_freeze_duty_time = '02:00';