Weblogic Server - Impact of increasing the JDBC Statement 'FetchSize'
Last updated on SEPTEMBER 29, 2017
Applies to:Oracle WebLogic Server - Version 18.104.22.168 and later
Information in this document applies to any platform.
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?
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