RAC Tuning

Oracle 12c    |    Intermediate
  • 9 videos | 41m 58s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
Ensuring that a database is performing at its optimum capacity is crucial for any database administrator. Explore key RAC monitoring and tuning techniques.

WHAT YOU WILL LEARN

  • describe the approach when tuning a RAC database and the effect of accessing blocks in the global cache
    describe the impact of accessing blocks in the global cache and maintaining cache coherency
    describe the importance of using wait events to diagnose performance problems and list some of the important wait event views
    describe the main global cache wait events for current and consistent read blocks
    describe the most frequent enqueue waits and how global enqueue wait events can impact an Oracle RAC database
  • list some of the most common tuning techniques that are particularly important for RAC
    describe reasons for index block contention and list ways to mitigate the problem
    describe the impact of frequently allocating space to a segment in RAC
    describe tuning considerations relating to undo blocks, high water marks, and serialized cross-instance calls

IN THIS COURSE

  • Locked
    1.  RAC Tuning Overview
    4m 3s
    After completing this video, you will be able to describe the approach for tuning a RAC database and the effect of accessing blocks in the global cache. FREE ACCESS
  • Locked
    2.  Analyzing Cache Fusion Impact in RAC
    4m 51s
    Upon completion of this video, you will be able to describe the impact of accessing blocks in the global cache and maintaining cache coherency. FREE ACCESS
  • Locked
    3.  Wait Events for RAC
    4m 35s
    Upon completion of this video, you will be able to describe the importance of using wait events to diagnose performance problems and list some of the important wait event views. FREE ACCESS
  • Locked
    4.  Global Cache Wait Events
    5m 30s
    Upon completion of this video, you will be able to describe the main global cache wait events for current and consistent reads. FREE ACCESS
  • Locked
    5.  Global Enqueue Waits
    4m 22s
    Upon completion of this video, you will be able to describe the most frequent enqueue wait events and how global enqueue wait events can impact an Oracle RAC database. FREE ACCESS
  • Locked
    6.  Common RAC Tuning Tips
    5m 2s
    Upon completion of this video, you will be able to list some of the most common tuning techniques that are particularly important for Oracle Real Application Clusters. FREE ACCESS
  • Locked
    7.  Index Block Contention Considerations
    6m 27s
    After completing this video, you will be able to describe reasons for index block contention and list ways to mitigate the problem. FREE ACCESS
  • Locked
    8.  High-Water Mark Considerations
    3m 5s
    Upon completion of this video, you will be able to describe the impact of allocating space to a segment frequently in RAC. FREE ACCESS
  • Locked
    9.  Other RAC Tuning Considerations
    4m 3s
    Upon completion of this video, you will be able to describe tuning considerations relating to undo blocks, high water marks, and serialized cross-instance calls. 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.