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


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



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
  • Course Number:
    od_odat_a07_it_enus

    Expertise Level
    Intermediate