dbaplus Community

Dec 12, 2019 · Databases

Why Did an Oracle SQLPROFILE Suddenly Trigger Massive Parallelism? A Real‑World Troubleshooting Tale

A production Oracle database suddenly ran queries with an excessively high degree of parallelism, prompting a DBA to investigate, discover an unexpected SYS‑owned SQLPROFILE as the root cause, and reflect on the need for stricter operational oversight.