1. Developer's Guide
  2. Oracle Data Provider for .NET Classes
  3. OracleConfiguration Class
  4. OracleConfiguration Performance Properties
  5. DefaultSDUSize

DefaultSDUSize

This property specifies the session data unit size (SDU) for Oracle networking communication between client and server.

Declaration

// C#
public static int DefaultSDUSize { get; set; }

Remarks

Before sending data across the network, ODP.NET or Oracle database buffers and encapsulates data into the SDU. They send the data stored in this buffer when the buffer is full, flushed, or when database server tries to read data. When large amounts of data are being transmitted or when the message size is consistent, adjusting the size of the SDU buffers can improve performance, network utilization, or memory consumption.

The default value is 65536 bytes, equivalent to 64 KB.

ODP.NET and Oracle database can each set its own SDU size. The actual SDU size used is negotiated at connect time. The smaller of the two values is chosen. Oracle Database 23ai uses a 64 KB SDU size. Earlier database releases set their default SDU size to 8 KB.

The OracleConfiguration SDU size can only be set before the first connection is established globally in the the .NET domain.

The OracleConnection SDU size can only be set before the connection is established. Moreover, the OracleConnection SDU size for a connection pool can only be set one time. All follow on set attempts are ignored for that pool.

See Also: