Oracle How-To Guides - Step-by-Step DBA Tasks
Task-focused guides for the operations DBAs perform every week. Each guide gives you the exact commands, the variations that matter, and the mistakes to avoid — no theory detours.
Storage & Tablespace Management
Section titled “Storage & Tablespace Management”- Create a Tablespace — permanent, temporary, undo, bigfile, and encrypted
- Add a Datafile to a Tablespace — extend tablespace capacity
- Resize Datafiles — grow and safely shrink datafiles
- Monitor Tablespace Usage — free space, growth trends, and alerts
- Switch Undo Tablespace Online — replace undo without downtime
Users & Schema Objects
Section titled “Users & Schema Objects”- Create a User with Grants & Privileges — roles, quotas, and profiles
- Create an Index — B-tree, bitmap, function-based, and online builds
- Create a Partitioned Table — range, list, hash, and interval partitioning
- Create a Database Link — public, private, and fixed-user links
Sessions & Performance
Section titled “Sessions & Performance”- Kill an Oracle Session — find SID/SERIAL#, handle zombies, RAC kills
- Gather Optimizer Statistics — DBMS_STATS for tables, schemas, and automation
Backup, Recovery & Data Movement
Section titled “Backup, Recovery & Data Movement”- Create an RMAN Backup — full, incremental, and compressed backups
- Recover a Database with RMAN — complete and point-in-time recovery
- Export a Schema with Data Pump — expdp with compression and filtering
- Import a Schema with Data Pump — impdp with remapping and conflict handling
Related Resources
Section titled “Related Resources”- RMAN Commands Cheat Sheet — quick RMAN syntax reference
- Utility Scripts Library — 350+ ready-to-run diagnostic scripts
- Oracle Error Reference — fixes for the errors these tasks can raise
- Performance Tuning Checklist — systematic tuning workflow