InitialLobFetchSize Property

In This Topic

Syntax
Remarks
See Also

Gets or sets the number of bytes of LOB data to prefetch and cache when querying data containing LOB columns. Default value is 0, which means no data is prefetched.

Syntax

Visual Basic
C#

public int InitialLobFetchSize {get; set;}

'Declaration
 
Public Property InitialLobFetchSize As Integer

Property Value

The number of bytes of LOB data to prefetch and cache when querying data containing LOB columns.

Remarks

Setting this property allows improving performance of getting data when the data contains small LOB values.

This property works only when the version of both Client and server is 11 or higher or in the Direct mode with the server 11 or higher.

Reference

OracleCommand Class
OracleCommand Members

Send Feedback