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 184.108.40.206 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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!