InitialLobFetchSize Property

In This Topic

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#

'Declaration
 
Public Property InitialLobFetchSize As Integer

public int InitialLobFetchSize {get; set;}

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.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleCommand Class
OracleCommand Members

Send Feedback