apps-dba journal

A working journal for Oracle DBAs.

October 30, 2026  ·   · 

Oracle DBA Lesson 106 Part 2 — Operate and hand off a database responsibly

A responsible database administrator connects an observed problem to evidence, chooses a change within the task's scope, verifies i...

Read the full lesson

October 30, 2026  ·   · 

Oracle DBA Lesson 106 Part 1 — Demonstrate a recoverable database service

A successful recovery returns an agreed consistent data state and a service the application can use. The assessment combines preparatio...

Read the full lesson

October 30, 2026  ·   · 

Oracle DBA Lesson 105 Part 3 — Respond to recovery-area pressure without destroying recovery

When recovery storage fills, the immediate task is to restore progress while keeping the files required for recovery and standby databa...

Read the full lesson

October 30, 2026  ·   · 

Oracle DBA Lesson 105 Part 2 — Follow a blocked transaction to its owner

An update can wait because another transaction has already modified the same row and has not committed or rolled back. Find the current...

Read the full lesson

Oracle DBA Lesson 106 Part 2 — Operate and hand off a database responsibly

A responsible database administrator connects an observed problem to evidence, chooses a change within the task's scope, verifies i...