Course Details

Previous Page


Oracle Database 12c RAC Administration: Global Resource Management


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Understanding global enqueues, instance locks, and cache fusion in a RAC database is essential in diagnosing performance problems, preventing outages, and tuning the database for optimum performance. This course covers Global Enqueue Management, which consists of global enqueues and instance locks, and Global Cache Management also known as cache fusion. Collectively Global Enqueue Management and Global Cache Management are known as Global Resource Management, a critical component of RAC architecture. This course is one of a series in the SkillSoft learning path that cover a portion of the objectives for exam 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure.

Target Audience
Oracle Database Administrators, Systems Administrators, Technical Consultants.

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Oracle Database 12c RAC Administration: Global Resource Management

  • start the course
  • describe the need for concurrency control in a RAC database and the role of the Global Resource Directory (GRD) in global concurrency control
  • describe how global resources are managed and list the background processes involved in global concurrency control
  • describe the process of allocating control of the master metadata for a specific entity to another instance
  • describe the roles of global enqueues and global instance locks
  • describe how global enqueues are used to control access to resources
  • list the objects that are subject to instance-wide locks
  • describe how concurrency is managed across multiple buffer caches
  • describe the important buffer states for cache fusion
  • list the scenarios where Global Cache Management controls concurrency for single-block reads
  • describe the steps involved when an instance wants to read a block that is not in the buffer cache
  • describe the steps involved when an instance wants to update a block that exists in at least one buffer cache in shared current state
  • describe the steps involved when an instance wants to update a block that exists in at least one buffer cache in exclusive current state
  • describe the steps involved when an instance wants to read a block which exists in at least one buffer cache in exclusive current state
  • describe multi-block read requests and identify some useful Global Cache Management views
  • use the GV$BH to explore the buffer states of a block being updated and read by multiple instances
  • Course Number:
    od_raad_a05_it_enus