1. the crash: deep diving into the alert log 2. why official oracle documentation is wrong here 3. isolating the […]
ora-04031 fixed: real root cause in oracle 19c (stop adding memory) Read Post »
introduction: waking up to a deceptive warning 1. the mechanics of a soft error versus a hard crash 2. digging
Decoding ORA-00700: The “Soft” Internal Error That DBAs Should Not Ignore Read Post »
introduction: the 3 am nightmare and the blue screen of death 1. the mechanics of a core dump: why ora-07445
Mastering ORA-07445 Core Dump Analysis: A Senior DBA’s Guide to Fixing Fatal Exceptions Read Post »
executive summary: the midnight batch crisis 1. anatomy of kksgaf-1: understanding memory corruption 2. the investigation phase: tracing the exact
Deep Dive: Solving ORA-00600 [kksgaf-1] Internal Error in Oracle 19c (19.18 RU) Read Post »
executive summary: the zero downtime challenge 1. pre-upgrade safeguards: the missing layer 2. autoupgrade tool version management 3. network configuration
executive summary: why choose autoupgrade? 1. critical pre-upgrade backups 2. upgrading grid infrastructure to 19c 3. installing oracle 19c database
introduction: why you shouldn’t just edit /etc/hostname 1. health check: prove the system is actually working 2. the asm chicken
introduction: why in-place patching is a bad idea 1. application simulation: proving zero downtime 2. the gold image strategy for
introduction: the struggle with shrinking batch windows 1. mastering parallel dml for massive data loading 2. understanding locking mechanisms and
