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.