JDBC OCI Ignores 'fetchsize' When Connecting to RAC Database with SCAN / TAF Configuration

(Doc ID 2124435.1)

Last updated on DECEMBER 08, 2017

Applies to:

JDBC - Version to [Release 12.1]
Information in this document applies to any platform.


A JDBC OCI connection to an 11g or 12c database ignores the 'fetchsize' setting when going over a RAC service (SCAN and TAF configuration).

The following output shows the time taken by a sample java program when fetchsize is 1 and 100 respectively:



Upgrade JDBC OCI from 11g to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms