JDBC OCI 12.1.0.2.0 Ignores 'fetchsize' When Connecting to RAC Database with SCAN / TAF Configuration (Doc ID 2124435.1)

Last updated on APRIL 07, 2016

Applies to:

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

Symptoms

A JDBC OCI 12.1.0.2.0 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:

 

Changes

Upgrade JDBC OCI from 11g to 12.1.0.2.0.

Cause

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