Note
For OceanBase Database V4.3.5, this parameter was introduced in V4.3.5 BP1.
Purpose
The unit_gc_wait_time parameter specifies the maximum wait time for unit garbage collection. If the specified time is reached, the system forcibly performs garbage collection.
Privileges
Query privilege
Both the
systenant and user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify privilege
Only the
systenant has the privilege to modify this parameter. User tenants do not have the privilege to modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Time |
| Default value | 1m, which indicates 1 minute |
| Value range | [0, 30d] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify it. |
| Effective upon OBServer node restart | No. The modification takes effect immediately. |
Remarks
When you modify the parameter value, you can add units such as us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), or d (days) to the parameter value.
Example
Set the maximum wait time for unit garbage collection to 1 minute. If the time reaches 1 minute, the system forcibly performs garbage collection.
obclient> ALTER SYSTEM SET unit_gc_wait_time = '1m';