skip to main content
DataDirect Connect Drivers : Oracle Driver : Connection Properties : SDUSize
  
SDUSize
Purpose
Specifies the Session Data Unit (SDU) that the driver requests when connecting to the server. The SDU is equivalent to the maximum packet size (size of database protocol packets sent across the network). This property serves only as a suggestion to the database server. The actual SDU that is used is negotiated with the database server.
This property is mutually exclusive with the TNSNamesFile and TNSServerName properties. The driver generates an exception if SDUSize is specified in conjunction with either of these properties.
Valid Values
x
where:
x
is an integer from 512 and 32767.
Behavior
If set to x, the driver sets the SDU to the specified size. For optimal performance, set this option to the maximum SDU size configured on the database server.
Notes
*If your application sends queries that only retrieve small result sets, you may want to use an SDU size smaller than the maximum SDU size configured on the database server. If a result set that contains only one or two rows of data does not completely fill a larger packet, performance will not improve by setting the value to the maximum SDU size.
Default
8192
Data Type
int
See also
Performance Considerations