MSAMM
Back to course

Oracle Apps DBA: Keeping E-Business Suite Alive · Module 3 · The database itself

The data dictionary, as a diagnostic tool

Lesson 30 of 184 · 2 min

The handful of views that answer most questions. LEARNING TO LOOK RATHER THAN TO REMEMBER. The data dictionary is the database describing itself, and the useful skill is not memorising view names — it is knowing that the answer is in there and how to find which view has it. THE QUESTIONS YOU WILL ASK ARE THE SAME FIVE, OVER AND OVER. What is running right now and what is it waiting on. Where has the space gone. What is this object and who owns it. What is the configuration actually set to. What went wrong recently. EACH HAS A SMALL SET OF VIEWS BEHIND IT, AND THE DICTIONARY IS SEARCHABLE. There is a view listing every view and a view listing every column, so "which view holds this" is a query rather than a memory test. That is the whole technique: look it up in the system in front…

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Oracle Apps DBA: Keeping E-Business Suite Alive, with a certificate on completion and a fourteen-day refund window.

See the course and enrol9 free lessons

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 3 · The database itself

  1. 1Instance and database: two different things
  2. 2Starting and stopping, properly
  3. 3Tablespaces and datafiles
  4. 4Redo: the reason recovery is possible
  5. 5Archive log mode, and the day it was off
  6. 6Undo, and read consistency
  7. 7Parameters, and the ones that matter here
  8. 8The data dictionary, as a diagnostic tool
  9. 9Reading an error you have never seenFree preview
  10. 10What breaks: four database-tier failures
  11. 11Lab briefing · Stop it, start it, break it