Oracle Database - AutoTask (Automated maintenance tasks)

Card Puncher Data Processing

About

The automated maintenance tasks infrastructure (known as AutoTask) schedules tasks to run automatically in Oracle Scheduler windows known as maintenance windows.

By default, one window is scheduled for each day of the week.

Privileges

grant execute on DBMS_AUTO_TASK_ADMIN to hr;

Management

List

COL CLIENT_NAME FORMAT a31
SELECT
  CLIENT_NAME,
  STATUS
FROM
  DBA_AUTOTASK_CLIENT;
CLIENT_NAME                     STATUS
------------------------------- --------
auto optimizer stats collection ENABLED
auto space advisor              ENABLED
sql tuning advisor              ENABLED

where:

Disable

BEGIN
  DBMS_AUTO_TASK_ADMIN.DISABLE (  
    client_name  => 'auto optimizer stats collection'
,   operation    => NULL
,   window_name  => NULL 
);
END;
/

Enable

BEGIN
  DBMS_AUTO_TASK_ADMIN.ENABLE (  
    client_name  => 'auto optimizer stats collection'
,   operation    => NULL
,   window_name  => NULL 
);
END;
/

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - SQL Tuning Advisor

Sql tuning advisor is scheduled as an autotask and can be managed with the dbms_sqltune Package.



Share this page:
Follow us:
Task Runner