This property specifies the total number of rows to retrieve per database round trip.

Declaration

// C#
public Int64 RowsToFetchPerRoundTrip { get; set; }

Property Type

System.Int64

Remarks

This property has no default value. If it is not set, then ODP.NET ignores this property.

The row data fetched in a single round trip applies to scalar types only, such as NUMBER and VARCHAR2 columns. If reference data types, such as LOBs, UDTs, and XMLType, exist in the result set, they are retrieved in separate round trips. These reference types can have their own fetch tuning parameters as reference type data sizes can vary in size from row to row, sometimes significantly.

RowsToFetchPerRoundTrip can be set before or after the OracleCommand executes on OracleConnection, OracleCommand, OracleDataReader, or OracleRefCursor. The value can also be changed after initial data fetches so that more or fewer rows are fetched on subsequent round trips. For OracleConfiguration, this property can only be set before the first connection opens.