RAC Global Resource Management

Oracle 12c    |    Intermediate
  • 15 videos | 1h 5m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 8 users Rating 4.5 of 8 users (8)
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

  • Locked
    1.  Global Resource Directory
    5m 22s
    Upon completion of this video, you will be able to describe the need for concurrency control in a RAC database and the role of the Global Resource Directory (GRD) in global concurrency control. FREE ACCESS
  • Locked
    2.  Global Resource Management
    4m 39s
    After completing this video, you will be able to describe how global resources are managed and list the background processes involved in global concurrency control. FREE ACCESS
  • Locked
    3.  Global Resource Remastering and Recovery
    3m 26s
    After completing this video, you will be able to describe the process of allocating control of the master metadata for a specific entity to another instance. FREE ACCESS
  • Locked
    4.  Global Enqueue Management Overview
    2m 54s
    Upon completion of this video, you will be able to describe the roles of global enqueues and global instance locks. FREE ACCESS
  • Locked
    5.  Global Enqueues
    3m 41s
    Upon completion of this video, you will be able to describe how global enqueues are used to control access to resources. FREE ACCESS
  • Locked
    6.  Instance Locks
    3m 29s
    Upon completion of this video, you will be able to list the objects that are subject to locks that apply to all instances. FREE ACCESS
  • Locked
    7.  Global Cache Management Overview
    4m 56s
    After completing this video, you will be able to describe how concurrency is managed across multiple buffer caches. FREE ACCESS
  • Locked
    8.  Global Cache Buffer States
    7m 19s
    Upon completion of this video, you will be able to describe the important buffer states for cache fusion. FREE ACCESS
  • Locked
    9.  Global Cache Management Single Block Reads
    3m 56s
    Upon completion of this video, you will be able to list the scenarios where Global Cache Management controls concurrency for single-block reads. FREE ACCESS
  • Locked
    10.  Read-from-Disk Cache Fusion Scenario
    3m 59s
    After completing this video, you will be able to describe the steps involved when an instance wants to read a block that is not in the buffer cache. FREE ACCESS
  • Locked
    11.  Read-Write Cache Fusion Scenario
    4m 18s
    After completing this video, you will be able to describe the steps involved when an instance wants to update a block that exists in at least one buffer cache in a shared current state. FREE ACCESS
  • Locked
    12.  Write-Write Cache Fusion Scenario
    4m 28s
    After completing this video, you will be able to describe the steps involved when an instance wants to update a block that exists in at least one buffer cache in exclusive state. FREE ACCESS
  • Locked
    13.  Write-Read Cache Fusion Scenario
    4m 36s
    After completing this video, you will be able to describe the steps involved when an instance wants to read a block which exists in at least one buffer cache in exclusive state. FREE ACCESS
  • Locked
    14.  Global Cache Management Multi-block Reads
    3m 37s
    Upon completion of this video, you will be able to describe multi-block read requests and identify some useful views for global cache management. FREE ACCESS
  • Locked
    15.  Exercise: Explore Cache Fusion Using Views
    4m 53s
    In this video, find out how to use the GV$BH to explore the buffer states of a block being updated and read by multiple instances. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Database Core Concepts
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Linux Administration
Rating 3.5 of 2 users Rating 3.5 of 2 users (2)
Book Database Performance at Scale: A Practical Guide