Learn the mysteries of how Oracle RAC Cache Fusion works. Cache Fusion is the secret to making Oracle RAC a scalable database platform. You will learn how cache fusion works, the differences between global cache current and consistent read transfers, the differences between two-way and three-way transfers and the associated wait events.
Oracle Ace and author Brian Peasland provides an in-depth demonstration of global cache transfers in action by utilizing Oracle Trace and session statistics (v$sesstat and v$statname).
Prerequisites: Knowledge of Oracle Architecture including the concept of an Oracle instance, the buffer cache, how data is moved into the buffer cache and an understanding of wait events.
Brian is a certified Oracle ACE who has been in the IT field for over 25 years and has worked as a computer operator, operations analyst, systems administrator, application developer and for more than half of his career as a database administrator. He holds a B.S. in Computer Science and a M.S. in Computer Science, specializing in database systems. Brian has been a member of SearchOracle.com’s Ask The Experts since 2001 and now contributes articles to the site. He regularly contributes to the My Oracle Support and Oracle Technet communities. He can be followed on Twitter on @BPeaslandDBA and maintains a blog at http://www.peasland.net.
Buy Brian’s new book “Oracle RAC Performance Tuning” at Amazon.
- Lectures 6
- Quizzes 0
- Duration 31 minutes
- Skill level All levels
- Language English
- Students 9
- Assessments Yes
- Lesson 1 – Agenda
- Lesson 2 – Demonstration: Cache Fusion in Action
- Lesson 3 – Demonstration Understanding Global Cache Statistics and Trace Output
- Lesson 4 – Demonstration: Global Cache Current Transfer vs Consistent Read Transfer
- Lesson 5 – 2-Way vs 3-Way Block Transfers
- Lesson 6 – How Oracle RAC Cache Fusion Works Summary