How AI Tools Are Transforming the Role of Database Administrators

Using Oracle Enterprise Manager (OEM) for Rapid Performance Diagnosis

OEM provides a graphical performance page that aggregates AWR, ADDM, and real‑time metrics. By opening the "Performance – Top Activity" screen you can instantly see sessions with high CPU, wait events, and SQL statements with the highest elapsed time.

Navigate to Performance → Top Activity .

Identify the “Top SQL” list; click a statement to view its execution plan and statistics.

From the context menu select “Create Tuning Job” to let the Optimizer Advisor generate recommendations.

Review the advisor output, apply index or hint changes, and re‑execute the job to verify improvement.

Oracle DB Console (DB Console) for Non‑SQL‑Savvy Users

The DB Console, accessible via the URL http://<host>:1158/em (or the version‑specific port), offers a lightweight web UI that does not require SQL*Plus knowledge.

Enable the console by setting EM_GLOBAL_PORT=1158 and starting the emctl start dbconsole service.

Use the “Top Activity” widget to locate high‑cost SQL statements and sessions.

For a selected SQL, click “Create Tuning Job” → “Run Advisor”. The advisor suggests index creation, statistics gathering, or SQL rewrite.

Apply the suggested changes directly from the console or via ALTER INDEX … REBUILD, EXEC DBMS_STATS.GATHER_TABLE_STATS, etc.

Why OEM/DB Console Matter for Oracle 10g and Later

Oracle 10g introduced automatic diagnostics (ADDM) and tuning advisors that are exposed only through OEM or DB Console. Using only sqlplus or third‑party editors bypasses these features, so DBAs miss the built‑in performance‑management capabilities.

Case Study: Hospital HIS System Optimization

A DBA enabled DB Console for a hospital’s IT staff, then demonstrated the following workflow:

Open DB Console and select “Top Activity”.

Identify a SQL with high CPU and I/O.

Click the statement, choose “Create Tuning Job”, and run the advisor.

Implement the advisor’s recommendation (e.g., create a missing index on TABLE_NAME(COLUMN1, COLUMN2)).

Re‑run the workload; CPU usage dropped by >50 % after optimizing ~30 statements over one month.

AI‑Assisted DBA Tools – Opportunities and Caveats

Modern AI assistants can generate SQL rewrites, suggest indexing strategies, and explain execution plans. However, AI may produce hallucinated recommendations; therefore a skilled DBA must validate any AI‑generated advice against the actual execution plan and database statistics.