high performance PL/SQL

Top 7 PL/SQL Performance Tuning Strategies for Bulk Processing

Cary Huang
March 11, 2026March 11, 2026
oracle

Introduction: Why PL/SQL Performance Tuning Strategies Matter When I work with busy Oracle systems, the biggest performance wins almost always come from tuning PL/SQL that handles bulk processing. These are the nightly jobs, ETL routines, and mass updates that can… Read More »Top 7 PL/SQL Performance Tuning Strategies for Bulk Processing

Top 7 PL/SQL Performance Mistakes with BULK COLLECT, FORALL and Pipelined Functions

Cary Huang
March 1, 2026March 1, 2026
oracle

Introduction: Why PL/SQL Performance Mistakes Hurt at Scale When I first started tuning server-side PL/SQL, I underestimated how much damage tiny inefficiencies could do once code hit production volumes. A single BULK COLLECT into memory, a careless FORALL, or an… Read More »Top 7 PL/SQL Performance Mistakes with BULK COLLECT, FORALL and Pipelined Functions