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.
Articles Related
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;
/