cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query Packet Size / Network Latency

former_member1170711
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

jcgood25
Active Contributor
0 Kudos

Perhaps there is a switch you can add to the connection string in the data server settings?