Oracle | DBMS_AUTO_TASK

Oracle DBMS_AUTO_TASK_IMMEDIATE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Zero delay initiation of optimizer stats gathering

AUTHID DEFINER

Dependencies

DBMS_AUTOTASK_PRVT

DBMS_LOCK

DBMS_SCHEDULER

Documented No

First Available 11.1

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsatsk.sql

GATHER_OPTIMIZER_STATS

Immediately gathers optimizer statistics dbms_auto_task_immediate.gather_optimizer_stats;

exec dbms_auto_task_immediate.gather_optimizer_stats;

      

      PL/SQL procedure successfully completed.