APEXPerformance

The hidden performance costs of APEX interactive reports

Mar 20, 2026 · 6 min

Interactive Reports feel free. They are not.

The three costs - Every user filter becomes a new bind-variable predicate — plan instability is real. - Aggregate/pivot views execute in the mid-tier session, not the DB. - Saved reports pin queries you may want to evolve.

What I do For anything over ~50k rows: switch to a Classic Report backed by a well-indexed view and expose only the filters that hit indexes.

Keep reading

ORA-01555: Snapshot too old — a practical checklist

The classic 'snapshot too old' error rarely means what beginners think. Here is the checklist I run through before touching UNDO_RETENTION.

APEX authentication schemes I actually use in production

SSO, custom or the built-in APEX accounts? After a decade of Oracle APEX projects, here is what I reach for by default — and when I break the rule.