apps-dba journal

A working journal for Oracle DBAs.

September 23, 2026

Oracle DBA Lesson 16 — Choose the Right Database Tool

The job picks the tool. SQL*Plus does not create a database. DBCA does not apply redo. A listener can answer while the instance is down...

Read the full lesson

September 22, 2026

Oracle DBA Lesson 15 — Choose Between Shared and Distributed Data

A company that serves several regions still has to decide what stays shared and what gets distributed. RAC, PDB consolidation, and shar...

Read the full lesson

September 20, 2026

Oracle DBA Lesson 14B — Recognize an In-Doubt Distributed Transaction

Oracle DBA · Lesson 14B Oracle DBA Lesson 14B — Recognize an In-Doubt Distributed Transaction A change that spans databases must...

Read the full lesson

September 20, 2026

Oracle DBA Lesson 14A — What Remains After a Session Fails

Read the full lesson

September 20, 2026

Oracle DBA Lesson 13B — Find an Archive Destination Problem

Oracle DBA · Lesson 13B Oracle DBA Lesson 13B — Find an Archive Destination Problem A data-file backup captures one point in ti...

Read the full lesson

September 19, 2026

Oracle DBA Lesson 13A — Follow an Online Redo Group Through Reuse

Oracle DBA · Lesson 13A Oracle DBA Lesson 13A — Follow an Online Redo Group Through Reuse Online redo groups rotate in a circle...

Read the full lesson

Oracle DBA Lesson 16 — Choose the Right Database Tool

The job picks the tool. SQL*Plus does not create a database. DBCA does not apply redo. A listener can answer while the instance is down...