DELETE and INSERT using OPENQUERY to Oracle require long delay between them
This turned out to be an issue with OPENQUERY and the related &quot;inconsistent metadata&quot; issue requiring OPTION (RECOMPILE). Switching to EXEC AT for write queries (UPDATE, INSERT and DELETE) resolved the throttling effect.