Note
- Due to internal optimization and refactoring, for V5.x versions, this parameter has been removed and is no longer used since V5.0.1 (for V4.4.2, it was removed starting from V4.4.2 BP1). The recycling of multi-version schema history data will be controlled by the scheduled task
SCHEDULED_RECYCLE_SCHEMA_HISTORY, and its scheduling interval can be modified using theSET ATTRIBUTEsubprogram inDBMS_SCHEDULER. - This parameter is available starting with V1.4.
Description
schema_history_recycle_interval specifies the interval at which the system executes the schema multi-version record recycling task.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Type | Time |
| Default value | 10m, which indicates 10 minutes |
| Value range | [0s, +∞)
Note
|
| 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. |
Examples
Set the interval at which the system executes the schema multi-version record recycling task to 10 minutes.
obclient> ALTER SYSTEM SET schema_history_recycle_interval = '10m';