Skip to Content
0
Aug 14, 2013 at 01:22 PM

SQL Query Packet Size / Network Latency

76 Views

This is probably a bit of a low level question for this forum but I will give it a try anyway.

When we run a SQL query against an Oracle database the packet sizes that we see coming back from Oracle are quite small resulting in a lot of added network latency. The packets are on the order of 255 bytes. When had our network expert do a capture of the network traffic. He is seeing that the TCP protocol "push flag" setting is set to 1 which apparently prevents buffering and causes the data to be streamed back as it becomes available. He says that this is something that would be normally set from the application side. In our case the application side is MII.

Does anyone know how this can be controlled to take advantage for larger packet sizes and cut down on the network latency?

Thank you,

Mike