Specifies the number of rows of data the driver attempts to fetch for each JDBC call.
Valid Values
0 | x
where:
x
is a positive integer that defines the number of rows.
Behavior
If set to 0, the driver uses the maximum page size for the Oracle Service Cloud database to which it is connecting (Operational or Report) for sites whose version is August 2014 or later. When connecting to sites whose version is prior to August 2014, the driver attempts to fetch up to a maximum of 10,000 rows. This value typically provides the maximum throughput.
If set to x, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than the maximum page size allowed can reduce the response time for returning the initial data. However, using a smaller WSFetchSize could improve response time for interactive applications.
Notes
If the value specified is greater than the value allowed by the server, the driver returns a warning that the setting exceeds the maximum value and uses the maximum value permitted. For servers prior to version August 2014, the maximum is 10,000 rows. For versions August 2014 or later, the maximum is server dependent.
FetchSize is related to, but different than, WSFetchSize. WSFetchSize specifies the number of rows of raw data that the driver fetches from the remote data source, while FetchSize specifies how many of these raw data rows the driver processes before returning data to the application. Processing the data includes converting from the remote data source data type to the driver SQL data type used by the application. If FetchSize is greater than WSFetchSize, the driver makes multiple round trips to the data source to get the requested number of rows before returning control to the application.
If the value specified is greater than the value allowed by the server, the driver returns a warning that the setting exceeds the maximum value and uses the maximum value permitted. For servers prior to version August 2014, the maximum is 10,000 rows. For versions August 2014 or later, the maximum is server dependent.