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