TRIGGER_WINDOW_COMPACTION_PROC

The TRIGGER_WINDOW_COMPACTION_PROC procedure is used to manually trigger window compaction.

Syntax

DBMS_DAILY_MAINTENANCE.TRIGGER_WINDOW_COMPACTION_PROC();

Considerations

• Only user tenants are allowed to initiate this procedure. The system tenant (sys tenant) does not support this.

• To manually trigger window compaction, the window compaction feature must be enabled (tenant-level parameter enable_window_compaction is set to True) and the window compaction task (DAILY_MAINTENANCE_WINDOW) must be enabled.

• This statement is used to manually trigger a single window compaction. It does not specify an end time for the task. The end time is determined by the max_run_duration attribute of the window compaction task (DAILY_MAINTENANCE_WINDOW). Users can set the duration parameter of the window compaction task (DAILY_MAINTENANCE_WINDOW) using the DBMS_SCHEDULER.SET_ATTRIBUTE procedure.

Examples

A user tenant manually triggers a window compaction.

obclient(root@mysql001)[(none)]> DBMS_DAILY_MAINTENANCE.TRIGGER_WINDOW_COMPACTION_PROC();

References

For more information about window compaction and related operations, see Window compaction.