RowsToFetchPerBlock

The maximum number of rows to fetch per stream if using the result set streaming API. The maximum number of rows to fetch per page if using pagination.

Note: While setting this option with a large value when using the result set streaming API can give you better fetch performance, it can also result in higher memory usage. This can be mitigated if the JDBC application can retrieve the result set from the connector quickly.

Default Value	Data Type	Required
10000 for result set streaming, 1000 for pagination	Integer	No