Oracle Database 12c RAC Administration: Global Resource Management

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

---

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

Expertise Level
Intermediate