Oracle query stalling when returning larger results

Caleb Spangler 0

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.

PRADEEPCHEEKATLA-MSFT 89,646 Reputation points Microsoft Employee

2023-11-01T04:48:46.5266667+00:00

@Caleb Spangler - Thanks for the question and using MS Q&A platform.

Could you please help us understand which Azure service are you using?
Caleb Spangler 0 Reputation points

2023-11-01T12:53:42.3833333+00:00

This is from an Azure VM Windows Server 2019.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-11-01T13:14:34.68+00:00

@Caleb Spangler I have added the right tag
vipullag-MSFT 26,311 Reputation points

2023-11-06T06:16:56.57+00:00

Hello Caleb Spangler
Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused.

This issue needs deeper investigation. Support team will be able to check and help on this. I would recommend you to open a azure support case.

Share via

Oracle query stalling when returning larger results

Your answer