skip to main content
Connection Option Descriptions : LOB Prefetch Size
  

Try DataDirect Drivers Now

LOB Prefetch Size

Attribute

LOBPrefetchSize (LPS)

Purpose

Specifies the size of prefetch data the server returns for BLOBs and CLOBs. LOB Prefetch Size 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 server 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 server 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

GUI Tab

Performance tab

See Also

Performance Considerations