How a Faulty Heartbeat Cable Crashed Our Oracle DB – A Detailed Post‑mortem

During a New Year holiday, an Oracle database suffered severe hangs due to a GC buffer busy acquire wait event caused by a faulty heartbeat network cable, leading to index unusable errors and extensive troubleshooting steps that reveal common causes and preventive measures.

Database PerformanceIndex UnusableNetwork Issue

0 likes · 6 min read

How a Faulty Heartbeat Cable Crashed Our Oracle DB – A Detailed Post‑mortem

dbaplus Community

May 30, 2016 · Databases

Why Uncommitted Updates in Oracle RAC Trigger Massive GC Waits and How to Fix Them

An Oracle RAC performance analysis shows that delayed commits on a configuration table cause frequent gc buffer busy acquire and gc cr block busy waits, dramatically slowing SELECT statements, increasing LMS/LGWR CPU usage, and prompting short‑ and long‑term mitigation strategies.

AWROracle RACcache fusion

0 likes · 17 min read

Why Uncommitted Updates in Oracle RAC Trigger Massive GC Waits and How to Fix Them