Oracle Database 11g Release 2: Managing Database Resources and the Scheduler

Overview/Description
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.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g Release 2: Managing Database Resources and the Scheduler

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

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