
Oracle Tablespaces: Understanding Space, Datafiles, and Capacity
A practical guide to checking Oracle tablespace usage, datafiles, autoextend, free space, and database storage capacity.
Technical knowledge, technical solutions and lessons learned across Oracle Database, cloud, infrastructure, automation and related technologies.
Articles based on real-world experience, technical investigations, migrations, troubleshooting and technical solutions.

A practical guide to checking Oracle tablespace usage, datafiles, autoextend, free space, and database storage capacity.

Key Oracle Data Guard checks for transport, redo apply, lag, archive gaps, standby redo logs, and overall standby database health.

How to use Oracle RMAN validation commands to check backup integrity and verify that database backups are usable for recovery.

A technical guide to reading Oracle AWR reports, understanding DB Time, wait events, SQL statistics, and execution plan changes.

Understanding Oracle wait events, wait classes, session waits, and how they help identify database performance problems.

How to trace Oracle Database performance issues from DB Time and wait events to the sessions and SQL statements causing the workload.
Explore scripts, diagnostics and utilities that complement the technical articles and support real database and infrastructure work.