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 is now availble. If you haven't you downloaded already: Why?

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