By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control over various aspects of scheduling, such as job windows and prioritizing jobs. This course explains how to configure the Database Resource Manager to access and create resource plans, create, configure, and administer consumer groups, as well as activate a resource plan and monitor the Resource Manager. This course also explores how to simplify management tasks by using the Scheduler to create, program, schedule, and monitor job execution as well as how to use a time-based or event-based schedule for executing Scheduler jobs. Incorporating advanced Scheduler concepts such as how to use the Scheduler to prioritize jobs is also covered. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
Learning Objectives
Managing Resources
- access and create resource plans and consumer groups using the Database Resource Manager
- use resource plan directives to plan and monitor resource allocation to consumer groups
- obtain Resource Manager information and monitor its functions
- address system resource utilization and control using the Database Resource Manager
Task Automation and Administration
- use the Scheduler to create, schedule, and monitor regular and lightweight jobs
- distinguish between time-based and event-based schedules
- perform advanced Scheduler administration
- manage Scheduler jobs on remote systems
- view Scheduler meta data