KILL_REFRESH

The KILL_REFRESH statement is used to actively terminate a materialized view refresh batch that is currently in progress and managed by the new scheduling framework.

Overview

After you call DBMS_MVIEW.KILL_REFRESH(refresh_id), the system performs the following operations on the refresh batch corresponding to the specified refresh_id:

• Mark tasks in the PENDING state as CANCELLED: All unscheduled tasks will be immediately canceled and will no longer enter the scheduling queue.
• Terminate tasks in the RUNNING state: For running tasks, the system locates their executing session and initiates a kill operation to forcibly interrupt their execution flow.
• Status convergence processing: Tasks that are killed are eventually marked with the status CANCELLED.
• Final states of tasks are not affected: Tasks that have already completed (SUCCESS), failed (FAILED), or been canceled (CANCELLED) will not be affected by this termination operation.

Syntax

DBMS_MVIEW.KILL_REFRESH(refresh_id)

Parameters

Examples

Terminates the refresh of the materialized view with refresh_id 100023.

obclient> CALL DBMS_MVIEW.KILL_REFRESH(100023);

References

For more information about refreshing materialized views, see Refresh a materialized view.