Oracle | DBMS_ADBTASK

Oracle DBMS_ADBTASK_ADMIN 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 APIs for administering Oracle Autonomous DataBase tasks

AUTHID DEFINER

Dependencies

ADBTASK_CLIENT	CDB_ADBTASK_CLIENT	DBMS_AUTOTASK_PRVT_LIB
ADBTASK_SCHEDULE	CDB_ADBTASK_SCHEDULE	DBMS_AUTO_TASK_ADMIN
ADBTASK_SETTINGS	CDB_ADBTASK_SETTINGS	DBMS_SPACE

Documented No

First Available 20c

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
{ORACLE_HOME}/rdbms/admin/prvtatsk.plb

Subprograms

DISABLE	ENABLE_TRACING	RUN_TASK_MANUAL
DISABLE_TRACING	MODIFY_ADBTASK_SETTINGS	SKIP_SUSPENSION
ENABLE

DISABLE

Disable an autonomous database task dbms_adbtask_admin.disable(task_name IN VARCHAR2);

SELECT * FROM adbtask_settings WHERE task_name = 'Auto Index Task';

      

      TASK_ID TASK_NAME                                             INTERVAL MAX_RT ENABLED

      ------- ----------------------------------------------------- -------- ------ -------

            3 Auto Index Task                                            900   3600 TRUE

      

      exec dbms_adbtask_admin.disable('Auto Index Task');

      

      SELECT * FROM adbtask_settings WHERE task_name = 'Auto Index Task';

      

      TASK_ID TASK_NAME                                             INTERVAL MAX_RT ENABLED

      ------- ----------------------------------------------------- -------- ------ -------

            3 Auto Index Task                                            900   3600 FALSE

DISABLE_TRACING (new 23ai)

Disable ADB Tracing dbms_adbtask_admin.disable_tracing;

exec dbms_adbtask_admin.disable_tracing;

      

      PL/SQL procedure successfully completed.

ENABLE

Enable an autonomous database task dbms_adbtask_admin.enable(task_name IN VARCHAR2);

SELECT * FROM adbtask_settings WHERE task_name = 'Auto Index Task';

      

      TASK_ID TASK_NAME                                             INTERVAL MAX_RT ENABLED

      ------- ----------------------------------------------------- -------- ------ -------

            3 Auto Index Task                                            900   3600 FALSE

      

      exec dbms_adbtask_admin.enable('Auto Index Task');

      

      SELECT * FROM adbtask_settings WHERE task_name = 'Auto Index Task';

      

      TASK_ID TASK_NAME                                             INTERVAL MAX_RT ENABLED

      ------- ----------------------------------------------------- -------- ------ -------

            3 Auto Index Task                                            900   3600 TRUE

ENABLE_TRACING (new 23ai)

Enable ADB Tracing dbms_adbtask_admin.enable_tracing;

exec dbms_adbtask_admin.enable_tracing;

      

      PL/SQL procedure successfully completed.

MODIFY_ADBTASK_SETTINGS (new 23ai overload)

Modifies the interval or maximum run time of an Autonomous Database task

Overload 1 dbms_adbtask_admin.modify_adbtask_settings( task_name IN VARCHAR2, attribute_name IN VARCHAR2, attribute_value IN NUMBER);

SELECT unique task_id, task_name, interval, max_run_time MAX_RT, SUBSTR(enabled,1,1) ENABLED

      FROM adbtask_settings

      ORDER BY 1,2;

      

      TASK_ID TASK_NAME                                             INTERVAL MAX_RT ENABLED

      ------- ----------------------------------------------------- -------- ------ -------

            0 AWR Warehouse Auto-Import                                  600    900 FALSE

            1 AWR Warehouse Auto-Export                                86400    900 FALSE

            2 KET Autonomous Task Test                                   900  10800 FALSE

            3 Auto Index Task                                            900   3600 FALSE

            4 Auto Statistics Management Task                            900   3600 FALSE

            5 Auto STS Capture Task                                      900    900 FALSE

            6 SQLQ: Auto-purge unused SQL quarantine configurations   604800    300 FALSE

            7 Auto SPM Task                                             3600   1800 FALSE

            8 Auto Zonemap Task                                         3600   3600 FALSE

            9 Auto-STS Flush                                             300    300 TRUE

           10 Auto-STS Purge                                           86400    600 TRUE

           11 Managed Stream Flush                                       300    900 FALSE

      

      exec dbms_adbtask_admin.modify_adbtask_settings('Auto Zonemap Task', 'INTERVAL', 7200);

      

      PL/SQL procedure successfully completed.

      

      SELECT * FROM adbtask_settings WHERE task_name = 'Auto Zonemap Task';

      

      TASK_ID TASK_NAME                                             INTERVAL MAX_RT ENABLED

      ------- ----------------------------------------------------- -------- ------ -------

            8 Auto Zonemap Task                                         7200   3600 FALSE

RUN_TASK_MANUAL (new 23ai)

Manually start ADB task dbms_adbtask_admin.run_task_manual(task_name IN VARCHAR2);

TBD

SKIP_SUSPENSION (new 23ai)

Undocumented dbms_adbtask_admin.skip_suspension(task_name IN VARCHAR2);

TBD

Overload 2 dbms_adbtask_admin.modify_adbtask_settings( task_name IN VARCHAR2, attribute_name IN VARCHAR2, attribute_value IN VARCHAR2);

TBD