dbaplus Community

Nov 6, 2015 · Databases

Misconfigured Oracle Parallel Parameters Caused a System Outage – DBA Case Study

In this detailed DBA case study, the speaker explains how improper settings of Oracle's parallel execution parameters on an AIX‑based 10gR2 database led to process saturation, undo‑related wait events, and temporary connection issues, and describes the step‑by‑step diagnosis, parameter adjustments, and lessons learned for future tuning.