Oracle | DBMS_ADBTASK

Oracle DBMS_ADBTASK_ADMIN Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose APIs for administering Oracle Autonomous DataBase tasks

AUTHID DEFINER

Dependencies

ADBTASK_CLIENT	CDB_ADBTASK_CLIENT	CDB_ADBTASK_SETTINGS
ADBTASK_SCHEDULE	CDB_ADBTASK_SCHEDULE	DBMS_AUTOTASK_PRVT_LIB
ADBTASK_SETTINGS

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

MODIFY_ADBTASK_SETTINGS

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

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

MODIFY_ADBTASK_SETTINGS (new 23c 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

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

TBD