My Oracle Support Banner

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


To view full details, 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 a vibrant support community of peers and Oracle experts.