process management blog posts

Tune fetch size to optimize large query performance in Oracle Database Service for Azure

Blog: Oracle BPM

When migrating from an environment where all the components are running locally, to a split stack architecture, you might have to tune network parameters to optimize performance. One of your first actions should be looking at the fetch size of the queries. This article explores the impact that can be made by tuning fetch sizes correctly.