oracle-performance-tuning git:20261019.6daae50A

Immutable. This exact content never changes and is served at /api/v1/blob/142facc4e218297b.

---
name: oracle-performance-tuning
description: Oracle AWR analysis, execution plan tuning, bind variables, and bulk collect optimization.
---

# Oracle Performance Tuning

1. Replace row-by-row cursor loops with `BULK COLLECT` and `FORALL` with bounded `LIMIT` clauses.
2. Require bind variables in dynamic SQL to eliminate hard-parse contention.
3. Inspect execution plans with `DBMS_XPLAN.DISPLAY_CURSOR` before adding optimizer hints.