Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?
(Choose three.)
A.
It creates jobs without considering the priorities associated with them.
B.
It translates tasks into jobs for execution by the scheduler.
C.
It determines the list of jobs that must be created for each maintenance window.
D.
It is spawned by the MMON background process at the start of the maintenance window.
E.
It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
Explanation:
AutoTask Overview
Oracle 11g added a new component to the Oracle automated task infrastructure, that began in Oracle 10g,
called AutoTask. AutoTask provides a central component that is responsible for management of scheduled
maintenance tasks.
AutoTask Architecture
AutoTask builds on much of the existing architecture of Oracle 10g. The AutoTask architecture consists of the
following components:
AutoTask Background Process (ABP) – APB is spawned by MMON and is responsible for managing the
AutoTask features. It coordinates the AutoTask clients and the scheduler. It also maintains AutoTask related
history that can be seen in the DBA_AUTOTASK_TASK view.
AutoTask Clients – Automated maintenance tasks that are scheduled by AutoTask. Oracle 11g includes clients
for statistics gathering, the Segment Advisor, and the Automatic SQL Tuning Advisor.
The AutoTask Maintenance Windows – Individual maintenance windows exist for different days of the week.
These windows can be modified as required.
Resource Manager – A resource plan is enabled that is designed to limit the amount of resources that the
AutoTask tasks can consume. This resource plan can be modified as required.
OEM – You can manage the start time and duration of the various AutoTask maintenance windows and add or
remove maintenance tasks with OEM. You can also use OEM to enable or disable maintenance tasks.
The Scheduler – AutoTask operations rely heavily on the Scheduler. The AutoTask architecture uses scheduler
windows and the scheduler infrastructure to execute AutoTask tasks.