Investigating a Chain of Events Resulting in Occasional Query’s Degraded Performance in Oracle May 29, 2023 A client asked us to verify why an INSERT AS SELECT statement, which was part of a scheduled ETL...
Statspack vs. AWR: Wrong number of SQL Executions October 27, 2021 This post is about a Statspack anomaly I discovered while analyzing execution trends of a...