• Online, Self-Paced
Course 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.

Learning Objectives

Global Resource Management Concepts

  • 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

 

Global Enqueue Management

  • 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

 

Global Cache Management

  • 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

 

Practice: Cache Fusion

  • use the GV$BH to explore the buffer states of a block being updated and read by multiple instances

 

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.