How Oracle RAC Cache Fusion Works
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.
This free training is segmented into several separate lessons:
- Lesson 1 – Agenda (6:02) (click on video below)
Brian’s introduction and tutorial agenda plus a brief history of Oracle clustering (parallel server) and the problems associated with disk pinging. (click to read the Transcript)
- Lesson 2 – Demonstration: Cache Fusion in Action (5:20)
Learn how Oracle RAC Cache Fusion really works. Brian Peasland demonstrates, with v$statname, v$sesstat and Oracle trace (dbms_monitor.session_trace_enable) cache fusion in action.
- Lesson 3 – Demonstration Understanding Global Cache Statistics and Trace Output (9:13)
A continuation of the cache fusion demonstration, with a detailed look at session statistics and the raw trace file contents. You will learn about the “gc” wait events (Global Cache) including ‘gc current block 2-way’ and ‘gc cr multi block request’.
- Lesson 4 – demonstration: Global Cache Current Transfer vs Consistent Read Transfer (4:38)
Learn the difference between a current block and a consistent read block.
- Lesson 5 – 2-Way vs 3-Way Block Transfers (4:07)
Brian demonstrates 2-Way vs 3-Way Block Transfers including a description of master, holders and requestors.
- http://youtu.be/Krs4qFnbLLc (2:03)
Oracle ACE and author Brian Peasland provides a summary of the “How Oracle RAC Cache Fusion Works” tutorial.
Date: Oct 19, 2015
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.