Emiel Ramakers

Principal Cloud Architect - Multicloud Specialist

Recent Blogs

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

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.

Addressing MTU issues in Oracle Database for Azure when PMTUD is blocked

Using Oracle Database Service for Azure, connected to a hub-and-spoke network, ICMP can be used to allow the PMTUD protocol to negotiate packet sizes between the networks. As it is not always possible to allow ICMP or you hit other Azure limitations, this blog explains details of various workarounds.

Implementing Oracle Database for Azure with a hub-and-spoke network

Using Oracle Database Service for Azure, connected to a hub-and-spoke network, internet control message protocol (ICMP) messages need to reach the spoke networks in Azure, so the Path MTU Discovery (PMTUD) protocol works, and all network traffic flows correctly. Without these steps, you can experience hanging connections across the multicloud network link. This blog explains the background and shares the optimal setup.

  1. View more