Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E10577-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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



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;