CANCEL_GATHER_STATS

CANCEL_GATHER_STATS is used to cancel the statistics collection command.

Syntax

DBMS_STATS.cancel_gather_stats (
      taskid         VARCHAR2
    );

Parameter description

Parameter	Description
taskid	The ID of the statistics collection task. Note You can query the GV$OB_OPT_STAT_GATHER_MONITOR view to obtain the taskid. For more information about this view, see GV$OB_OPT_STAT_GATHER_MONITOR.

Examples

CALL DBMS_STATS.CANCEL_GATHER_STATS(taskid);

info

In this example, taskid must be replaced with the actual value.