Overview
recyclebin_object_expire_time is used to automatically clean up expired schema objects in the recycle bin.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Only the
systenant can modify this parameter. User tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default Value | 0s: Disable automatic purge of the recycle bin. |
| Value range | 0s, +∞) |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
When the value is not 0s, it indicates that the schema objects were moved to the recycle bin a while ago.
Configuration example
Disable the automatic cleanup of the recycle bin.
obclient> ALTER SYSTEM SET recyclebin_object_expire_time = "0s";Enable automatic cleanup of the recycle bin and reclaim schema objects that have been in the recycle bin for more than 7 days.
obclient> ALTER SYSTEM SET recyclebin_object_expire_time = "7d";
References
[Empty Recycle Bin