RAC Global Resource Management
Oracle 12c
| Intermediate
- 15 videos | 1h 5m 35s
- Includes Assessment
- Earns a Badge
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 controlDescribe how global resources are managed and list the background processes involved in global concurrency controlDescribe the process of allocating control of the master metadata for a specific entity to another instanceDescribe the roles of global enqueues and global instance locksDescribe how global enqueues are used to control access to resourcesList the objects that are subject to instance-wide locksDescribe how concurrency is managed across multiple buffer cachesDescribe the important buffer states for cache fusion
-
List the scenarios where global cache management controls concurrency for single-block readsDescribe the steps involved when an instance wants to read a block that is not in the buffer cacheDescribe the steps involved when an instance wants to update a block that exists in at least one buffer cache in shared current stateDescribe the steps involved when an instance wants to update a block that exists in at least one buffer cache in exclusive current stateDescribe the steps involved when an instance wants to read a block which exists in at least one buffer cache in exclusive current stateDescribe multi-block read requests and identify some useful global cache management viewsUse the gv$bh to explore the buffer states of a block being updated and read by multiple instances
IN THIS COURSE
-
5m 22sUpon 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
-
4m 39sAfter 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
-
3m 26sAfter 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
-
2m 54sUpon completion of this video, you will be able to describe the roles of global enqueues and global instance locks. FREE ACCESS
-
3m 41sUpon completion of this video, you will be able to describe how global enqueues are used to control access to resources. FREE ACCESS
-
3m 29sUpon completion of this video, you will be able to list the objects that are subject to locks that apply to all instances. FREE ACCESS
-
4m 56sAfter completing this video, you will be able to describe how concurrency is managed across multiple buffer caches. FREE ACCESS
-
7m 19sUpon completion of this video, you will be able to describe the important buffer states for cache fusion. FREE ACCESS
-
3m 56sUpon completion of this video, you will be able to list the scenarios where Global Cache Management controls concurrency for single-block reads. FREE ACCESS
-
3m 59sAfter 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
-
4m 18sAfter 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
-
4m 28sAfter 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
-
4m 36sAfter 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
-
3m 37sUpon 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
-
4m 53sIn 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 Performance Tuning
Channel
Oracle RAC