My Oracle Support Banner

WebLogic Server: Impact of increasing the JDBC Statement 'FetchSize' (Doc ID 2311855.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

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

Goal

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?  

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

Will there be memory problems?

Solution

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
Goal
Solution


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