Note
This parameter was introduced in OceanBase Database V3.1.4.
Notice
The expired data deletion (TTL) feature is only supported in OceanBase KV scenarios and is disabled in SQL scenarios. Enabling it in SQL scenarios may lead to unexpected and erroneous data deletion.
Privilege requirements
Query the parameter
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Both the
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | False |
| Value range |
|
| Modifiable | Yes, can be modified using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Configuration example
Disable the TTL background task.
obclient> ALTER SYSTEM SET enable_kv_ttl = false;