Performance Tuning

Home - Oracle Database - Performance Tuning
Oracle APEX ORDS connection pool exhaustion

Oracle APEX ORDS Connection Pool Exhaustion: A Real Incident, Two Root Causes, One Permanent Fix

A real production incident on a CRM platform I maintain: the Oracle ORDS connection pool ran dry under normal business-hours load. Two unrelated anti-patterns were

READ MORE
SQL queries production database

Stop Running These 5 SQL Queries on Your Production Database

It was a Tuesday afternoon. One query. No WHERE clause. Fourteen thousand customer records, gone in under a second. That story is not unique. It

READ MORE
5 PLSQL Mistakes I Made as a Junior Oracle Developer

5 PL/SQL Mistakes I Made as a Junior Oracle Developer (And How to Fix Them)

When I first started writing PL/SQL, I honestly thought I was doing great. My code worked, the data was moving, and nobody was complaining. But

READ MORE