Advanced DBA
Advanced Oracle DBA deep-dives — RAC wait events, AWR interpretation, online partitioning, and the tuning work you actually do on production systems.
AWR is Talking, Are You Actually Listening? A Practical Guide to Reading What Matters
How to read an AWR report as a conversation rather than a symptom lookup — context, load profile, wait-event patterns, SQL and segments.
gc buffer busy acquired: The RAC Wait Event That Ruined My Weekend
A RAC gc buffer busy acquired war story — how an application optimisation concentrated hot blocks and doubled transaction times.
How to Partition a Large Table Online in Oracle Without Downtime (DBMS_REDEFINITION)
Converting a 20TB monolithic table to range-interval partitioned IOT with LOB compression — online, using DBMS_REDEFINITION.
Enabling/Disabling Database Options in Oracle Enterprise Edition with chopt
Use the chopt utility to disable unlicensed Oracle Enterprise Edition options and avoid licensing surprises on 11.2 and later.
Fix ORA-01017: ASMSNMP User Missing After Grid Infrastructure Install
Why DBCA fails with ORA-01017 after an 11.2.0.4 Grid Infrastructure install — the ASMSNMP user is missing, and here is how to create it.
Distilled.
Deep technical posts on Oracle performance, RAC, Exadata, and AI-assisted DBA workflows.