28 DBMS_AUTO_TASK_IMMEDIATE

The DBMS_AUTO_TASK_IMMEDIATE package consists of one subprogram whose function is to initiate gathering of optimizer statistics without delay.

This chapter contains the following topics:

Summary of DBMS_AUTO_TASK_IMMEDIATE Subprograms

Table 28-1 DBMS_AUTO_TASK_IMMEDIATE Subprograms

Subprogram	Description
GATHER_OPTIMIZER_STATS Procedure	Initiates gathering of optimizer statistics without waiting for the start of a maintenance window

This procedure initiates gathering of optimizer statistics without waiting for the start of a maintenance window.

Syntax

DBMS_AUTO_TASK_IMMEDIATE.GATHER_OPTIMIZER_STATS;