Automated Task Scheduling
The gather_stats_job uses a specific
scheduler class called auto_task_job_class. This class is
also created by the database and is associated with a specific
resource group called auto_task_consumer_group.
To control resources used by
gather_stats_job, the DBA has to define a resource plan and
specify the resource to allocate to the
auto_tasks_consumer_group. Then the resource plan has to be
associated with the maintenance_window_group.
Next,
invoking SQL Access Advisor through
the
Oracle
Enterprise
Manager
will be examined.
Using SQL Access Advisor
through OEM
To access the SQL Access Advisor through
the Enterprise Manager, do the following steps:
-
Go to Advisor Central and click the SQL
Access Advisor link.
Figure 7.10 – SQL Access Advisor
-
This starts a wizard. It will
prompt
for a workload source.
