RAC Tuning
Oracle 12c
| Intermediate
- 9 Videos | 41m 58s
- Includes Assessment
- Earns a Badge
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 cachedescribe the impact of accessing blocks in the global cache and maintaining cache coherencydescribe the importance of using wait events to diagnose performance problems and list some of the important wait event viewsdescribe the main global cache wait events for current and consistent read blocksdescribe 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 RACdescribe reasons for index block contention and list ways to mitigate the problemdescribe the impact of frequently allocating space to a segment in RACdescribe tuning considerations relating to undo blocks, high water marks, and serialized cross-instance calls
IN THIS COURSE
-
1.RAC Tuning Overview4m 3s
-
2.Analyzing Cache Fusion Impact in RAC4m 51s
-
3.Wait Events for RAC4m 35s
-
4.Global Cache Wait Events5m 30s
-
5.Global Enqueue Waits4m 22s
-
6.Common RAC Tuning Tips5m 2s
-
7.Index Block Contention Considerations6m 27s
-
8.High-Water Mark Considerations3m 5s
-
9.Other RAC Tuning Considerations4m 3s
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.