apps-dba journal

A working journal for Oracle DBAs.

Exam-ready SQL, Exadata, E-Business Suite, and OCI — written the way you actually use it: examples first, then the rule, then a quiz.

September 19, 2026

Oracle DBA Lesson 5B — Working in the Right Container

Oracle DBA · Lesson 5B Working in the Right Container Your session is always in one container. Confirm it with SHOW CON_NAME bef...

Read the full lesson

September 19, 2026

Oracle DBA Lesson 5A — CDB Anatomy

Oracle DBA · Lesson 5A CDB Anatomy Root, seed, and application PDBs sit inside one CDB. Know which container you are in before y...

Read the full lesson

September 19, 2026

Oracle DBA Lesson 4 — Why Pluggable Databases Exist

Oracle DBA · Lesson 4 Why Pluggable Databases Exist Separate application databases each want their own instance — memory, backgr...

Read the full lesson

September 18, 2026

Oracle DBA Lesson 3 — Single Instance vs RAC

Oracle DBA · Lesson 3 Single Instance vs RAC Copy a Data Guard runbook onto a RAC cluster — or the reverse — and you stop the ...

Read the full lesson

September 18, 2026

Oracle DBA Lesson 2 — What a Session Is

Oracle DBA · Lesson 2 What a Session Is “I have 2,000 connections” might mean sockets, sessions, or server processes. Those are ...

Read the full lesson

September 18, 2026

The Instance and the Database

Oracle DBA · Lesson 1 The Instance and the Database Oracle has two parts: what is running, and the files that keep saved data...

Read the full lesson

Oracle DBA Lesson 5B — Working in the Right Container

Oracle DBA · Lesson 5B Working in the Right Container Your session is always in one container. Confirm it with SHOW CON_NAME bef...