Oracle Scheduler - Oracle 10g/11g Data and Database Management Utilities - page 194

Window Groups : When a job is required to be scheduled on different windows, you
can define several windows and then group them under a single name. Let's assume
a maintenance job is chosen to be run when the workload is lower during weekends,
nights and holidays. There are two regular windows— Weekend , and Weeknight ,
and several other windows, each one defining one holiday. All of these windows can
be grouped under a Window Group named Maintenance_Window .

Window Group

Job

Weekend

M T W T F S S

Resource Manager : The Resource Manager is a means of providing the DBA with
more control over resource allocation. It specifies the amount of resources a process
may use, it determines the degree of parallelism, the CPU emphasis, the maximum
blocking time, and the maximum idle time, among other resources. In the Scheduler
context, it specifies the resource limits for a Window or a Job Class. Resource
Manager represents an entire subsystem of DBA resource control and is closely
tied to Services (previously discussed). The Oracle Scheduler has been designed to
integrate with that subsystem.

Resource Manager

OLTP
group
DSS
group

OLTP
group
DSS
group

10%

90%

CRM
Plan

DWH
Plan

10% 90%

WeekNight
Window

WeekDay
Window

08:00 17:00 22:00 07:00