Automated Task Scheduling
For prudent allocation of resources among
competing jobs, the Scheduler makes use of a job class and a
window. A job class is a category of jobs that share the common
resource usage requirements and other characteristics. Using a
database resource plan, the DBA can control resources for each
job and prioritize them.
A window is an interval of time with a
well-defined beginning and end time. The window helps to
prioritize among job classes based on a schedule. The
gather_stats_job is automatically created during database
creation. This task executes the
dbms_stats.gather_database_stats_job_proc procedure and uses
the Scheduler.
Two windows are defined automatically:
Changing the time interval, repeat
frequency, and resource plan can customize the windows. These
two windows belong to a pre-defined group called maintenance_
window_group.
