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.

March 01, 2026

eBooks

Practical, hands-on PDF guides written for Oracle DBAs - real examples, scripts, and step-by-step walkthroughs you can use immediately. More titles coming soon.
Available Now
Oracle Exadata DBA Complete Guide
apps-dba.com

Oracle Exadata DBA - The Complete Guide

Available Now

Everything an Oracle DBA needs to understand, manage, and troubleshoot Exadata - from architecture fundamentals to Smart Scan internals, Flash Cache tuning, Storage High Availability, and real-world performance scenarios. Written from hands-on experience.

  • Exadata Architecture and Components
  • Smart Scan and Cell Offloading
  • Smart Flash Cache (Write Back / Write Through)
  • Storage Cell Disks and ASM Disk Groups
  • Storage High Availability
  • Background Processes
  • Performance Tuning on Exadata
  • Troubleshooting Common Issues
Format: PDF Level: Intermediate to Advanced Audience: Oracle DBAs
$25 USD
Buy on Gumroad Instant PDF download after purchase
Coming Soon
Oracle Cloud (OCI) DBA Guide
apps-dba.com

Oracle Cloud Infrastructure (OCI) for DBAs

Coming Soon

A practical guide for Oracle DBAs moving to the cloud - covering OCI VM Database Systems, Autonomous Database, networking, backups, patching with dbcli, and Bastion Service.

  • OCI VM Database Systems (VMDB)
  • Autonomous Database
  • OCI Networking for DBAs
  • Patching with dbcli
  • Bastion and Secure Access
  • Backup and Recovery on OCI
Coming Soon
📊
Oracle Performance Tuning Handbook
apps-dba.com

Oracle Performance Tuning Handbook

Coming Soon

Deep dive into Oracle SQL tuning - reading execution plans, using AWR and ASH, managing indexes, SQL Plan Baselines, parallelism, and memory tuning based on real production scenarios.

  • Reading Execution Plans
  • AWR, ASH and ADDM
  • Index Design and Tuning
  • SQL Plan Baselines (DBMS_SPM)
  • Parallelism and Memory
  • Real Production Case Studies
Coming Soon

No comments:

Post a Comment

Non-Equijoins and Self-Joins in Oracle SQL

Non-Equijoins and Self-Joins in Oracle SQL Non-Equijoins and Self-Joins in Oracle SQL: Complete Guide Most joins in SQL use the e...