Skip to main content

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

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. 🚀

Labels:

Comments

Post a Comment

Popular posts from this blog

🚀 Automating Oracle Database Patching with Ansible: A Complete Guide

Oracle database patching has long been the bane of DBAs everywhere. It's a critical task that requires precision, expertise, and often results in extended maintenance windows. What if I told you that you could automate this entire process, reducing both risk and downtime while ensuring consistency across your Oracle estate? 💡 In this comprehensive guide, I'll walk you through a production-ready Ansible playbook that completely automates Oracle patch application using OPatch. Whether you're managing a single Oracle instance or hundreds of databases across your enterprise, this solution will transform your patch management strategy! 🎯 🔥 The Challenge: Why Oracle Patching is Complex Before diving into the solution, let's understand why Oracle patching is so challenging: 🔗 Multiple dependencies : OPatch versions, Oracle Home configurations, running processes ⚠️ Risk of corruption : Incorrect patch application can render databases unusable ⏰ Downtime requirements : Da...
Post a Comment
Read more

Oracle RAC Switchover & Switchback: Step-by-Step Guide

 Ensuring business continuity requires regular Disaster Recovery (DR) drills. This guide covers the Switchover and Switchback process between Primary (DC) and Standby (DR) databases . Pre-checks Before Performing Switchover Before starting the activity, ensure there are no active sessions in the database. If any are found, share the session details with the application team, get their confirmation, and terminate the sessions. Primary Database Name: PRIMARY Standby Database Name: STANDBY  Identify Active Sessions set lines 999 pages 999 col machine for a30 col username for a30 col program for a30 compute sum of count on report break on report select inst_id,username,osuser,machine,program,status,count(1) "count" from gv$session where inst_id=1 and program like 'JDBC%' group by inst_id,username,osuser,machine,program,status order by 1,2; select inst_id,username,osuser,machine,program,status,count(1) "count" from gv$session where inst_id=2 and program lik...
Post a Comment
Read more

Mastering Oracle RAC with SRVCTL Commands

Oracle Real Application Clusters (RAC) provide high availability, scalability, and manageability for databases. One of the most powerful tools for managing RAC databases is srvctl , a command-line utility that allows administrators to control various database services. This blog explores essential srvctl commands to help you efficiently manage Oracle RAC environments. 1. Checking Database Configuration and Status  List all available databases on the host:                  srvctl config database   Check the status of a specific database and its instances:                    srvctl status database -d <database_name>   Retrieve detailed status information about a database, including its instances and states:                    srvctl status database -d <database_name> -v 2. Stopping and Starting Databases   ...
Post a Comment
Read more