The TRIGGER_WINDOW_COMPACTION_PROC subprogram is used to manually trigger window compaction.
Syntax
DBMS_DAILY_MAINTENANCE.TRIGGER_WINDOW_COMPACTION_PROC();
Usage instructions
Can only be initiated by a user tenant. The system tenant (
systenant) does not support this operation.To manually trigger window compaction, the window compaction feature must be enabled (the value of the tenant-level parameter enable_window_compaction must be
True) and the window compaction task (DAILY_MAINTENANCE_WINDOW) must be enabled.This statement is used only to manually trigger a one-time window merging. It does not specify the task end time, which is determined by the
max_run_durationattribute of the window merging task (DAILY_MAINTENANCE_WINDOW). Users can set this via thedurationparameter of the window merging task (DAILY_MAINTENANCE_WINDOW) using theDBMS_SCHEDULER.SET_ATTRIBUTEsubprogram.
Examples
Manually trigger a major compaction for the user tenant.
obclient(root@mysql001)[(none)]> DBMS_DAILY_MAINTENANCE.TRIGGER_WINDOW_COMPACTION_PROC();
References
For more information about major compaction, see Major Compaction.