CANCEL_GATHER_STATS

2025-11-14 07:33:32  Updated

CANCEL_GATHER_STATS is used to cancels a statistics collection command.

Syntax

DBMS_STATS.cancel_gather_stats (
      taskid         VARCHAR2
    );

Parameters

Parameter Description
taskid The ID of the statistics collection task.

Notice

You can query the GV$OB_OPT_STAT_GATHER_MONITOR view for the taskid. For more information about this view, see GV$OB_OPT_STAT_GATHER_MONITOR.

Example

obclient> CALL DBMS_STATS.CANCEL_GATHER_STATS(taskid);

Note

Replace taskid with the actual value.

Contact Us