Skip to main content

Welcome to Josi's LAB

Start here

Have you tried turning it off and on again?

Runbooks, scripts and notes for Oracle DBAs, written from real support work. Every page is meant to be used with a terminal open next to it.

What you will find

The content is split into three shelves. Open a shelf to see its books.

Where to start

If you want toGo to
Learn the daily work of a DBA from the beginningOracle DBA Starter Guide
Find a script for a day-to-day taskAdministration
Investigate a slow query or a busy databasePerformance
Work on the operating system sideLinux for Oracle DBAs
Look up a query, a view or a cheat sheetReference
Install or set up a databaseOracle Install & Setup
Publish a site, set up SSL or run containersInfra & Cloud

How to navigate

  1. Shelves group books by subject. Books are split into chapters, and each page covers one task or one script.
  2. The search box at the top looks through every page. Search for a script name, an error code such as ORA-01555, or a view such as v$session.
  3. Inside a book, the left sidebar lists its chapters and pages. On long pages, Page Navigation jumps between headings.
  4. The Books link in the header lists everything in one place, including books that are not on a shelf.

How the pages are written

  • Scripts are ready to copy. Read a script before you run it, and try it outside production first.
  • Names are placeholders. Replace values such as PRODDB1, dbserver01 and example.com with your own.
  • Coloured boxes carry the warnings. An information box gives context. A warning box marks a command that can affect a running database.
  • Some features need a license. Pages that rely on AWR, ASH or SQL Monitor need the Diagnostics and Tuning packs. Check Before you start: licenses.
New here? Open How to use this guide in the Starter Guide and follow the chapters in order.

More from the lab