Essential Free Tools Every Oracle DBA Should Master

Oracle DBAs need reliable, low‑cost tools to monitor, diagnose, and maintain databases; this article shares nine free utilities that cover recording OS activity, real‑time performance, query analysis, visual management, automated diagnostics, health checks, data collection, backup/recovery, and enterprise monitoring.

TOP1: OS Watcher

OS Watcher records all OS events, storing hourly gzip files for three days by default (configurable). Start with startOSW.sh, stop with stopOSW.sh. For RAC environments, configure prvnet to capture private network heartbeats.

TOP2: oratop

Similar to Unix top, oratop provides near‑real‑time metrics for single‑instance, RAC, Active Data Guard, and 12c multitenant databases. Run oratop and connect to the database (e.g., system/manager@dbhost:4800/db1.domain.com).

TOP3: ora (Fast‑hand tool)

Unlike oratop, ora offers responsive, SQL‑centric queries, consolidating many checks into simple commands such as ora active|wc -l, ora sqltext SQL_ID, ora plan SQL_ID, and ora size to inspect active sessions, SQL text, execution plans, and table sizes.

TOP4: SQL Developer

For those preferring a GUI, the free Oracle SQL Developer (latest 4.1.3) replaces paid tools like Toad or PL/SQL Developer, offering query editing, debugging, and data modeling.

TOP5: AWR/ASH/ADDM

These built‑in scripts reside in $ORACLE_HOME/rdbms/admin. AWR provides hourly snapshots (adjustable to 30 minutes for performance‑sensitive systems), ASH captures active session history for specific intervals, and ADDM performs automated diagnostics.

TOP6: ORAchk

Formerly RACcheck, ORAchk performs health checks on OS kernel parameters, patches, RAC configuration, CRS/Grid, ASM, and database settings, outputting results in HTML. Exadata users can also use exachk.

TOP7: RDA (Remote Diagnostic Agent)

RDA gathers comprehensive diagnostic data without altering the system. Modules can be listed with ./rda.sh -L modules and selected (e.g., ./rda.sh -S OS DB DBA INST). It covers areas such as ACFS, ASM, APEX, B2B, EXA, and many others.

TOP8: RMAN

RMAN is essential for backup and recovery; regular backup verification (including annual restore tests) is recommended to ensure data safety.

TOP9: OEM Cloud Control (CC)

Oracle Enterprise Manager evolved from a single‑node tool to OEM 13c Cloud Control, supporting database, RAC, and broader infrastructure monitoring. Remember the OSM utility for storage management.

Mastering these tools equips a DBA with the skills of a mid‑level professional, covering monitoring, optimization, and backup tasks.