Senior DBA Field Notes

Production Oracle, written by someone who’s been paged for it.

AWR analysis, RAC and Exadata internals, RMAN recovery, and the operational edge cases that documentation skips — drawn from 13+ years running core banking databases.

Performance & AWR
RAC / Exadata
RMAN / Recovery
Data Engineering
Unallocated — coming soon

RMAN Active Duplicate: Cloning a Production Exadata RAC Database Step by Step

  RMAN Active Duplicate: Cloning a Production Exadata RAC Database Step by Step Cloning a database sounds simple until you've done it o...

Read post →

Redis Enterprise Active-Active (CRDB) Basics for Oracle DBAs Moving into NoSQL

  Redis Enterprise Active-Active (CRDB) Basics for Oracle DBAs Moving into NoSQL If you've spent your career in Oracle RAC and Data Gua...

Read post →

How to Read an Oracle AWR Report Step by Step: A Senior DBA's Field Guide

How to Read an Oracle AWR Report Step by Step: A Senior DBA's Field Guide If you've been an Oracle DBA for more than six ...

Read post →

Oracle 19c Automatic Indexing: A Senior DBA's Deep Dive Into What It Really Does

Oracle 19c Automatic Indexing: A Senior DBA's Deep Dive Into What It Really Does If you have ever inherited a production sche...

Read post →

IBM DB2 - Database drop commands

 IBM DB2 - Database drop commands  Removing The Old Database: Login into db2inst2 Login and execute the below commands db2 disconnect all db...

Read post →

IBM DB2 - Database Creation Steps

IBM DB2 - Database Creation Steps   Below provided are the steps I have used to create a database in IBM db2 database engine.  Connect to db...

Read post →

Space Reclamation Procedure for Oracle tables - Move tablespace

 Space Reclamation Procedure for oracle objects: move tablespace There are various space reclamation procedures available for the oracle dat...

Read post →