dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / FetchSize Property

FetchSize Property (OracleCommand)
Gets or sets the number of rows that will be transferred across the network at a time.
Syntax
'Declaration
 
Public Property FetchSize As Integer
 

Property Value

The number of rows that will be transferred across the network at the same time. The default value is 0.
Remarks
If 0 value is assigned, a value of this parameter will be determined automatically and it will be changed dynamically when executing read operations. If you do not want to have a specific number of rows be fetched at a time, it is better to keep this default value.
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

See Also