Determines whether streaming or materialization (client caching) is used when the driver fetches LOB and XML data. In most cases, streaming provides better performance; however, materialization can reduce network round trips to the database server when updating LOB data using Clob and Blob objects, which can improve performance.
Valid Values
streaming | materialize
Behavior
If set to streaming, the driver determines the most efficient way to return LOB and XML data based on the following conditions:
Whether streaming is supported by the database server
Whether the application requests the data as a stream
For example, if streaming is supported by the database server and an application requests LOB data for a row as a stream, the driver uses streaming to transport the data. If streaming is not supported by the database server or if the application requests the data as a byte array or a String, the driver fully materializes the data on the client.
If set to materialize, the driver fully materializes the data on the client instead of using streaming.