GC 2-Way and 3-Way Buffer Cache in Oracle RAC

Oracle RAC uses a shared cache architecture where each instance has its own buffer cache. To maintain consistency, Oracle uses the Global Cache Service (GCS) to coordinate access across nodes using mechanisms known as GC 2-Way and GC 3-Way buffer transfers.

🔁 What is Global Cache in RAC?

Global Cache ensures block consistency across instances in a RAC cluster. Instead of fetching from disk, Oracle RAC uses Cache Fusion to transfer blocks over the interconnect between nodes, reducing I/O and improving performance.

⚡ GC 2-Way Buffer Transfer

A GC 2-Way transfer happens when the block is shipped directly from the current holder to the requesting instance in just two messages.

• 🔁 Request: Instance A → Instance B
• 📦 Response: Instance B → Instance A

This is fast and efficient because it avoids additional overhead.

📘 Example

Instance A runs a DML and needs a block held by Instance B in exclusive mode. B sends it directly to A, completing the transfer in two messages.

⚠️ GC 3-Way Buffer Transfer

A GC 3-Way transfer involves three messages. This happens when the GCS must coordinate the block transfer, such as during ownership conflict or heavy workload.

• 🔍 Request: Instance A → GCS
• 🔄 GCS → Block Holder (Instance B)
• 📦 Block: B → A (or via GCS)

This is slower due to more messaging and resource coordination.

📘 Example

Instance A requests a block. The GCS finds Instance B has it but is busy or the block needs role conversion. The block is transferred after GCS coordination, resulting in a 3-message round trip.

🆚 GC 2-Way vs GC 3-Way Summary

🔍 Feature	GC 2-Way	GC 3-Way
🔁 Messages	2	3+
⚙️ Transfer Type	Direct from holder	Indirect via GCS
⚡ Performance	Faster	Slower
📦 Block Path	Instance B → A	Via GCS or redirected

📊 Monitoring GC Transfers

Use this SQL to inspect GC performance:

SELECT name, value 
FROM v$sysstat 
WHERE name LIKE 'gc%';

Focus on metrics like:

• gc current block 2-way
• gc current block 3-way
• gc cr block receive time

🔧 Tuning Tips

• 🎯 Use service affinity to minimize cross-instance block requests
• 📶 Ensure low latency interconnect (Infiniband/10G+)
• 🔥 Avoid "hot blocks" shared by multiple instances

Understanding GC internals is crucial for every Oracle RAC DBA to ensure cluster performance and stability. 🚀