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.