../E40758-03.epub /> ../E40758-03.mobi />

30 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 30-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



GATHER_OPTIMIZER_STATS Procedure

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

Syntax

DBMS_AUTO_TASK_IMMEDIATE.GATHER_OPTIMIZER_STATS;