My Oracle Support Banner

Weblogic Server - Impact of increasing the JDBC Statement 'FetchSize' (Doc ID 2311855.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

Oracle WebLogic Server - Version 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.