Purpose

Specifies whether the driver optimizes network traffic to the Oracle server.

Valid Values

1 | 2

Behavior

If set to 1, the driver does not optimize network traffic when communicating with the Oracle server.

If set to 2, the driver optimizes network traffic for result sets that contain repeating data in some or all of the columns when the repeating data is in consecutive rows. It also optimizes network traffic if the application is updating or inserting images, pictures, long text data, or binary data.

Notes

  • This connection property can affect performance. In some scenarios, setting the value to 1 may produce better results.

Default

2

Data Type

int

See also

Performance Considerations