Purpose

Specifies the size of prefetch data the driver returns for BLOBs and CLOBs. LOBPrefetchSize is supported for Oracle database versions 12.1.0.1 and higher.

Valid Values

-1 | 0 | x

where:

x
is a positive integer that represents the size of a BLOB in bytes or the size of a CLOB in characters.

Behavior

If set to -1, the property is disabled.

If set to 0, the driver returns only LOB meta-data such as LOB length and chunk size with the LOB locator during a fetch operation.

If set to x, the driver returns LOB meta-data and the beginning of LOB data with the LOB locator during a fetch operation. This can have significant performance impact, especially for small LOBs which can potentially be entirely prefetched, because the data is available without having to go through the LOB protocol.

Default

4000

Data Type

int