Oracle query stalling when returning larger results

Caleb Spangler 0 Reputation points

I'm facing an issue where queries to tables with a higher number of records get stuck, and traffic stops between the client and ODA. This problem only occurs in our Azure environment. When I execute the query, the return statement runs for about 30 seconds, and then everything freezes. Although the connection appears to remain open, no records come through. Wireshark logs show PSH/ACK attempts from both the client and database.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
6,303 questions
{count} votes