TRIGGER_WINDOW_COMPACTION_PROC

The TRIGGER_WINDOW_COMPACTION_PROC procedure is used to manually trigger a window compaction.

Syntax

DBMS_DAILY_MAINTENANCE.TRIGGER_WINDOW_COMPACTION_PROC();

Considerations

• Only user tenants can initiate this procedure. The system tenant (sys tenant) does not support it.

• To manually trigger a window compaction, the window compaction feature must be enabled (tenant-level parameter enable_window_compaction 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 this parameter using the DBMS_SCHEDULER.SET_ATTRIBUTE procedure.

Examples

A user tenant manually triggers a window compaction.

obclient(sys@oracle001)[SYS]> DBMS_DAILY_MAINTENANCE.TRIGGER_WINDOW_COMPACTION_PROC();

References

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