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 ...
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 ...