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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.