Overview
enable_window_compaction specifies whether window-based compaction is used for the current tenant.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Bool |
| Default Value | False |
| Value range |
|
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
Window compaction is jointly controlled by the parameter enable_window_compaction and the window compaction task DAILY_MAINTENANCE_WINDOW. The relationship between their values and daily major compaction behavior is as follows:
enable_window_compaction |
DAILY_MAINTENANCE_WINDOW |
Daily major compaction behavior |
|---|---|---|
| False | False(CALL DBMS_SCHEDULER.DISABLE('DAILY_MAINTENANCE_WINDOW');) |
Trigger daily tenant major compaction |
| False | True(CALL DBMS_SCHEDULER.ENABLE('DAILY_MAINTENANCE_WINDOW');) |
Trigger daily tenant major compaction |
| True | False (CALL DBMS_SCHEDULER.DISABLE('DAILY_MAINTENANCE_WINDOW');) |
No major compaction is performed, meaning neither window-based major compaction nor daily tenant major compaction is triggered. |
| True | True(CALL DBMS_SCHEDULER.ENABLE('DAILY_MAINTENANCE_WINDOW');) |
Trigger a major compaction |
Configuration example
You have enabled the window merging feature for the current tenant.
obclient> ALTER SYSTEM SET enable_window_compaction = True;
References
For more information about major compactions, see Major Compaction.