Weblogic Server - Impact of increasing the JDBC Statement 'FetchSize'

(Doc ID 2311855.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle WebLogic Server - Version 12.1.1.0 and later
Information in this document applies to any platform.

Goal

Environment: WLS 12.1.1, DB 12.1

Customer is using Weblogic 12.1.1 and seeing that our SQL query performance using JDBC. It could be enhanced greatly by increasing the fetchSize from the default 10 to a higher number. Is there any reason why Oracle defaults this to 10? What the repercussions of setting this to a high value such as 1000?  

Customer is not changing the Weblogic's Datasource configuration. They want to implement this in their application code when creating a JDBC statement and then do a setFetchSize().

Will we run into memory problems?


 

Solution

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