RAC Global Resource Management

Oracle 12c    |    Intermediate
  • 15 Videos | 1h 12m 35s
  • Includes Assessment
  • Earns a Badge
Likes 1 Likes 1
Global Enqueue Management is essential in diagnosing performance problems, preventing outages, and tuning the database for optimum performance. Explore concepts related to Global Enqueue Management.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 8 Likes 8