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 ValueData TypeRequired

10000 for result set streaming, 1000 for pagination

Integer

No