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 A utonomous D ataB ase 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
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