Search notes:

Oracle: AutoTasks

select *
from
   dba_scheduler_window_groups
 where
   window_group_name = 'MAINTENANCE_WINDOW_GROUP';
Predefined automated maintenance tasks
Maintanance tasks can be enabled or disabled with dbms_auto_task_admin
Automated maintenance task job names begin with ORA$AT (this constant is used as where condition in dba_autotask_job_history)
See also select * from dba_scheduler_window_groups where window_group_name like 'ORA$AT%' and select * from dba_scheduler_groups where group_name like 'ORA$AT%'.
The default job class for autotasks is ora$autotask_job_class.

Predefined maintenance windows

By default, there are seven predefined maintance windows, one for each day of the week.
The duration of SATURDAY_WINDOW and SUNDAY_WINDOW is longer than that of the other windows.
The predefined maintainance windows can be adjusted with dbms_scheduler.set_attribute.
By default, all predefined maintenance windows use the resource plan DEFAULT_MAINTENANCE_PLAN, but any resource plan can be assigned to any maintanance window by including the subplan ORA$AUTOTASK in the new plan.
Automated maintenance tasks run under its subplan ORA$AUTOTASK. This subplan divides its portion of total resource allocation equally among the maintenance tasks.

See also

dba_autotask_client_job, dba_autotask_client, dba_autotask_job_history, dba_autotask_window_clients, dba_autotask_client_history

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759612223, '216.73.216.149', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/autotasks/index(76): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51