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.
Oracle RMAN Backup Progress Monitoring: Scripts & V$SESSION_LONGOPS
Two practical SQL scripts for monitoring RMAN backup progress — compression ratio, percent complete, and estimated finish time.
Configuring Bidirectional Replication using Oracle GoldenGate 12c
Step-by-step GoldenGate 12c bidirectional replication setup on Oracle 12.1 and Solaris 11.2 SPARC — Extract, DataPump and Replicat.
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.