Oracle DBA Lesson 17B — Run a Repeatable SQL*Plus Report

A report you will run again is a script: fixed line and page size, column formats, a spool file, and an exit that means what it says. A...

Read the full lesson

Oracle DBA Lesson 17A — Connect and Check Your SQL*Plus Session

Connect through a service, not through ORACLE_SID . Prove the session: SHOW USER , SHOW CON_NAME , and the USERENV service name. EXIT ...

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...

Read the full lesson

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