Recent stories

Investigating a Chain of Events Resulting in Occasional Query’s Degraded Performance in Oracle

Investigating a Chain of Events Resulting in Occasional Query’s Degraded Performance in Oracle


A client asked us to verify why an INSERT AS SELECT statement, which was part of a scheduled ETL job executing on a ...

7 min read
Statspack vs. AWR: Wrong number of SQL Executions

Statspack vs. AWR: Wrong number of SQL Executions


This post is about a Statspack anomaly I discovered while analyzing execution trends of a particular SQL on one of our ...

9 min read